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.