.CSV to SQL CE Table?

Question

Is there any way to quickly import data from a .csv or tab delineated .txt into a SQL Compact Edition 3.5 Table?

I have a large amount of data that is impractical for manual input.

I know I can use the BULK INSERT function if I wanted to import into a Server Based SQL Database, but this method does not work in SQL CE.

I use visual studio 2010 and I have SQL Server Management Studio installed.

Any help will be appreciated!

Answer 1

You can use my VS Add-in, which generates INSERT statements based on a CSV file: http://sqlcetoolbox.codeplex.com