Bulk INSERT into SQL Server CE -


I still am using WebMatrix for a site, and its underlying SQL Server Compact database, and it's fine, But it only makes you one line at a time. There is no facility to add any bulk (as I hope). But, see if I have thousands of rows in the spreadsheet.

I used Nevatat for SQL Server, which defines a table name, it will automatically import the spreadsheet into the table! About thousands of rows, all within about 30 seconds. How do I get Navicat for SQL Server to connect to Webmatrix's database for my website so that I can store it on a larger scale?

I have a bulk insert library, which you can use:

Comments