Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from Access to SQL Server. SSMA for Access automates conversion of Microsoft Access database objects to SQL Server database objects, loads the objects into SQL Server, and then migrates data from Microsoft Access to SQL Server.

SSMA for Access v5.3 is designed to support migration from Microsoft Access 97 and higher to all editions of SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014.

Files

Status: Deleted This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to October 2017.

No files found

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

• Windows 7, Windows 8.1, Windows Server 2003, Windows Server 2008, Windows Server 2008 R2, Server 2012.

• Microsoft Windows Installer 3.1 or a later version.
• The Microsoft .NET Framework version 3.5 or a later version. You can obtain it from the .NET Framework Developer Center.
• Access to and sufficient permissions on the computer that hosts the target instance of SQL Server.
• DAO provider version 12.0 or 14.0. You can install DAO provider from Microsoft Office 2010/2007 product or download it from Microsoft web site.
• Microsoft SQL Server Native Client (SNAC) version 10.5 and above. You can install SNAC from Microsoft SQL Server web site as part of SQL Server Feature Pack.
• 4 GB RAM.

After the download, you must extract the installation files before you can install SSMA for Access.

Installing the SSMA for Access Client

1. Double-click SSMA for Access.exe.
2. On the 'Welcome' page, click Next.
3. If you do not have the prerequisites installed, a message will appear that indicates that you must first install required components. Make sure that you have installed all prerequisites, and then run the installation program again.
4. Read the End User License Agreement. If you agree to the terms, select "I accept the agreement" option and click Next.
5. Read the 'Usage Report Settings' page, select or clear the feature reporting box, and then click Next.
6. On the 'Choose Setup Type' page, click Typical.
7. Click Install.