bulk insert

Hi, currently I have text file showing as this Class_ID, USER_ID, SOURCE_NO 10001:A01:AAA01 10002:A02:AAA01 10003:A03:AAA01 10004:A04:AAA01 10005:A05:AAA02 <-- this is wrong, I need to compare within text file as well. Did anyone know how to bulk insert the data I read from text file? it many...

Ok, I have a very specific situation that this would be useful for. I have a DataTable with a large number of columns(200+) that I am doing a bulk insert for in SQLite, since it does not support Update Table like SQL Server does. I want to know if there is a way after I iterate over all the...