Showing posts with label attach. Show all posts
Showing posts with label attach. Show all posts

Monday, March 12, 2012

How to import MS Access database into SQL Server 2005

Hello,

I have a database MS access: test.mdb.

Is it possible to attach to SQL SERVER 2005 (or 2000 than to 2005), or any other solution ?

I need to transfer all the application:

structure and data.

How to do it?

Microsoft has a tool called the Access Upsizing Wizard. There are different versions for different versions of Access.

http://support.microsoft.com/kb/325017

|||

I googled a bit, no screentshot I can find

Anyway, In SSMS -> DB -> right-click, choose "Task" -> "Import"

pick "Microsoft Access" from the Data Source dropdown, and it asks for "File Name", "User name:", "Password"

You might have to do it table by table though

As above said, found this through SQL 2005 Books Online (Upsizing Wizard)

http://www.sqljunkies.com/howto/bd909d1e-3ea1-4323-889e-5e3a5415b977.scuk

|||

Thank to everybody,

http://www.microsoft.com/sql/solutions/migration/access/default.mspx

here the migration tool.