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.