Most users of access who have upsized their app to SQL will be familiar with the various wizards in the recent releases that facilitate data transfer to SQL Server. However sometimes this approach won’t work. A client recently came to me with an issue relating to an older access database which used data access pages to allow data input through web pages. The problem was that in trying to open the application in the later versions of access that have the migration wizards – the database appeared to corrupt when it was converted.
So the alternative approach is to use a SQL Server utility called Sql Server Migration Assitant for Access which you can find here.
In addition
The free Microsoft SQL Server Migration Assistant (SSMA) makes it easy to migrate data from Oracle, Microsoft Access, MySQL, and Sybase to SQL Server. SSMA converts the database objects to SQL Server database objects, loads those objects into SQL Server, migrates data to SQL Server, and then validates the migration of code and data.