SQL Server Compact 3.5: Process/import CSV data
I have a CSV file which I wish to manipulat开发者_如何学Ce using SQL Server Compact (CE) 3.5
How can I bulk insert the data into a temporary table?
You can read the csv data into a DataTable and the load it using http://sqlcebulkcopy.codeplex.com - you could use http://www.csvreader.com/ and avoid loading into a DataTable.
精彩评论