Friday, December 22, 2006

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.

2 comments:

Anonymous said...

Hey, landed on your blog, nice stuff. I found a cool new tool for our blogs... www.widgetmate.com It helps get latest news for our keywords directly on to our blog. I added it on mine. Worked like a charm.

Vinit Bhansali said...

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")