Microsoft has released MS SQL Server Migration Assistant for Access v4.2
for Access and SQL Server developers in order to enable data migration from MS Access to SQL Server.
Developers and database administrators can download Microsoft SQL Server migration assistant for Access free tool from Microsoft Download Center
Using migration assistant tool, developers will enable Access to SQL Server 2005, Access to SQL Server 2008, Access to SQL Server 2008 R2 and Access to SQL Azure with minimal effort
I think SQL Server Migration Assistant is a good database migration software who are looking for a free well performing data migration tool.
Microsoft SQL Server Migration Assistant or its common name SSMA, is a toolkit which enables developers easily convert Microsoft Access database objects to MS SQL Server database objects. SSMA then deploys converted MS Access objects to SQL Server.
SQL Server Migration Assistant for Access can also be used as a data migration tool from Access to SQL Server.
Using SQL Server Migration Assistant for Access administrators and developers can migrate sql database objects and migrate data from Access 97 and higher versions to any edition of the Microsoft SQL Server.