Categories
Uncategorized

Importing Access database into Sql Server 2005

Today I had a need to import an old Access database into Sql Server 2005. First I tried with Sql Server Manager Import function but I quickly gave up on it as it was yielding many errors for some reason. Next I googled for a solution and found that MS is giving SQL Server Migration Assistant for Access (there are versions for other source databases) which is a full blown application that lets you configure many import parameters, mappings and other useful stuff.

It worked like a charm for me.

One reply on “Importing Access database into Sql Server 2005”

Leave a Reply