MS SQL to Access

[FAQ] [Release Notes] [Download] [Buy]
Latest version 6.1 released 05/13/2024

MS SQL to Access converter is a program to migrate SQL Server databases to MS Access. The program has high performance due to direct connection to source and destination databases (it does not use ODBC or any other middleware). Command line support allows to script, automate and schedule the conversion process.

Features

All versions of MS SQL are supported (including Azure SQL)
Exports MS SQL databases into MS Access 2007/2010/2013/2016/2019/2021
Fast conversion engine (100MB MS SQL database - in 10 minutes on average modern system)
Converts indexes with all necessary attributes
Option to filter data using SELECT-queries
Option to merge MS SQL data into an existing MS Access database
Option to convert individual tables
Command line support
Support for multibyte character sets
Stores conversion settings into profile
Quick Launch
Easy-to-use wizard-style interface
Full install/uninstall support
The product can be customized according to customer requirements
Unlimited 24/7 support service
1-year subscription for updates

Limitations

Does not convert views
Does not convert foreign keys
Does not convert stored procedures and triggers
Demo version converts only 50 records per table

Requirements

Supported OS: Windows 7/8/10/11, Server 2008/2012/2016/2019/2022, Linux with WINE (contact us if you need version for Windows XP or Server 2003)
Microsoft Access/Office or Access Runtime installation
SQL Server environment (server or client components of SQL Server must be installed on the same machine where you run SQL Server to Access converter)

Quick Launch

Once you stored conversion settings into profile you can run the program in Quick Launch mode. Just launch Windows Explorer and double-click on the profile description (.m2a) file with left mouse button. This will cause MS SQL to Access wizard to launch conversion loading the necessary settings from the specified profile. Then you will be taken right to the screen with progress of conversion without entering all conversion settings.

I am using the MSSQL-to-Access for many years now. This is an excellent program and absolutely a time saver in daily data manipulations. And, the technical support from Intelligent Converters has always been great.
Mansour Shoari, De Beers Canada

The Intelligent Converter team is very helpful and responsive. We have also received custom versions of the tool.
Melanie Paris, SNAP Inc.

I will certainly recommend your program to my associates who might need such.
Lynn Lease

I am fully satisfied with your product & already used this application in dozens of my new projects.
Dhurba Joshi

Try before you buy

Still not sure the program fits your needs? Try free demo version with limited features. It converts only 50 records per database table. Test the quality of the demo and come back to place an order if satisfied with the results.

Download trial version of MS SQL to Access

Ordering

For online credit card purchasing select the desired software package in the table below and click the corresponding ORDER NOW link. MS SQL to Access converter is covered by 30 day money-back guarantee


MS SQL to Access (single user license)	$59	ORDER NOW

MSSQL Migration Toolkit software pack to convert any data source to MS SQL and vice versa	$149	ORDER NOW