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