Migrate Microsoft Access database to SQL Server database

Microsoft provides a tool called SQL Server Migration Assistant for Access (SSMA for Access).

The tool can be found at: http://www.microsoft.com/sql/solutions/migration/access/default.mspx

You can use this tool to migrate your existing access databases over to sql server.