I found a solution to import Access Data to SQL Server easily using SQL Server Migration Assistant (SSMA) for Access. This is a free tool from Microsoft that comes with three versions (Access, Oracle, and Sybase).
Below I will guide you to how to use it:
1. Before you get started, you need a license key for using this application which can be obtained from Microsoft after some registration.
2. After you get the license key, put it on folder:
C:\Documents and Settings\[Your username]\Application Data\Microsoft SQL Server Migration Assistant\a2ss
3. Create a new SSMA project
4. File > Add Databases, browse an access database file (mdb) you want to migrate and check mark your newly added database
5. Connect to your SQL Server
6. Choose your SQL database destination
7. Finally, click “Convert, Load, and Migrate” button, SSMA will automatically do the rest, you can see the report after finish
Note: You can also do the process one by one using buttons: “Convert Schema”, “Load to Database”, and “Migrate Data”
No related posts.
Tags: database, migrate, msaccess, sql server