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.