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

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 开发者_Python百科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.

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

https://web.archive.org/web/1/http://blogs.techrepublic%2ecom%2ecom/10things/?p=391

http://web.archive.org/web/20080823140515/http://sqlserver2000.databases.aspfaq.com:80/how-do-i-upsize-from-access-to-sql-server.html

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

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