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.