CODEWITHSUNDEEP
sql-server-2005ms-access
StevieB
StevieB

Reputation: 6533

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

Upvotes: 1

Views: 5481

Answers (2)

marc_s
marc_s

Reputation: 754478

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.

Upvotes: 3

Capsule
Capsule

Reputation: 6159

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.

Upvotes: 0

Related Questions