Importing data into SQL Express
While there is no easy way to do this there still is a way
1) Export your Excel, Csv etc into an Access database
2) Create an odbc connection to your SQLExpress database
3) Using the table export function in Access you can export the data into SQLExpress
You can use other ways too but I find this most efficient and easy way to do it.
1 comment:
Well, if it's only a single sheet of data being exported into a single table (with the table structure already matching the fields in the csv/xls file, you could just copy/paste the data into visual studio's database view (open a database, then right-click on a table and click "show data")
Post a Comment