Import a .MDB file into SQL Server 2005

Hey I have a .MDB file which contains a database for an old site which I have to upgrade to SQL Server 2005. I'm very familiar with SQL Server 2005 but know very little about Access and .MDB files.

Can someone demonstrate 开发者_开发百科the steps in which I can Import a .MDB database into SQL Server 2005. With preferably doing it from SQL Server Management Studio.

Thanks in advance

There are lots of ways to do this - manually or with the help of some wizards.

Check out Microsoft SQL Server 2005 - Migration for Microsoft Access for guidance and grab the SQL Server Migration Assistant for Access (SSMA for Access) to upgrade easily.

You could define a new DSN which connects to your SQL2005 server, then create the same DB structure in SQL2005.

Load your MDB into access. Connect to your new DSN within Access, then you can simply copy/paste rows between the 2 databases.