If all free stuff doesnt work for you for some reasons, the last resource is to export your Ms Access data to Ms Excel.
From Ms Excel, you could easily insert them into Ms Sql Server without much problem. However, you may need to do a bit of admin manually by comparing the design view of both databases. Find the difference in the design view of each table and update them accordingly on the Ms Sql Server.
This should help :-)
|