Want to switch from Access to SQL Server ?
Using AccessToMsSql, you can migrate from Access to SQL Server easily and fast, just a few mouse clicks!
Here you can download and install AccessToMsSql.
Copy table struct and data from Access to SQL Server
Click “Wizard – Import All Tables” at task dialog.
then show the wizard.
1. Open Source Access.
2. Select Destination SQL Server.
3. Select tables to migrate.
Will copy selected tables struct (field, primary key, index, auto increament, nullable) and data both.
4. Migrate.
More about AccessToMsSql – the tool to convert Access database to SQL Server