How to import ".mdb" files into SQL Server 2008?

[thedougster]

Assuming it can be done (as I've been told):

How do I import ".mdb" (MS Access / OleDb) files (specifically, Northwind sample database files) into SQL Server 2008 (Express with Advanced Features)?

 

[HarleyQuinn]

Could you do this using the Upsizing wizard (Tools-->Database Utilites-->Upsizing Wizard) in Access?

I'm pretty sure you can also do this using SSIS to import the mdb as well.

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.