How to transfer my data from MS ACCESS DB to a new SQL SERVER DB?

Question

Hello,

I have a contact DB that I created 3 years ago in MS ACCESS. After 1 year learning ASP.NET/C#, I'm comfortable witting application now for my office. So, I would like to create the same application in web (using ASP.NET/C#/SQL SERVER) so that anybody in my department can access. Meanwhile, there are at least 127 contacts, preventing me from just start a new DB from scratch.

So, those are my questions:

Is is a way I can transfer my data from the ACCESS DB to the SQL SERVER DB? Should I write a small application that read data from the ACCESS file and write it to my new SQL SERVER DB?
Is there a software that can do that?

Thanks for the help.

Answer 1

If you use SQL Management Studio, there is an "Import" wizard that will whisk the data into your new database for you.

Microsoft have a KB article here: http://support.microsoft.com/kb/321686

Apologies - the above article is indeed for Excel - the Access version is here:

http://support.microsoft.com/kb/250616/en-us

Answer 2

Hi,

SQL Server hat an import and export tool. Take a look at this.

Answer 3

Microsoft has an upsizing wizard specifically for this purpose. It's not perfect but it is quick and dirty if that is what you're after. Some links before you get started:

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

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

http://blogs.techrepublic.com.com/10things/?p=391

http://sqlserver2000.databases.aspfaq.com/how-do-i-upsize-from-access-to-sql-server.html