Microsoft SQL Server Migration Assistant for Access is a tool for migrating databases from Access to SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2. SSMA 2008 for Access also supports migrating to SQL Azure. SSMA for Access converts Access database objects to SQL Server database objects, loads those objects into SQL Server, and then migrates data from Access to SQL Server. You can also link Access tables to SQL Server tables so that you can continue to use your existing Access front-end applications with SQL Server or SQL Azure. SSMA for Access supports migration from Access 97 and higher to any edition of SQL Server.
More Info: Download