sql-server-migration-assistant-for-access-accesstosql.md

title	SQL Server Migration Assistant for Access (AccessToSQL)
description	Learn about SSMA for Access and follow step-by-step instructions for migrating Access databases to SQL Server or Azure SQL Database.
author	nilabjaball
ms.author	niball
ms.reviewer	randolphwest
ms.date	12/30/2025
ms.service	sql
ms.subservice	ssma
ms.topic	concept-article
ms.collection	sql-migration-content
f1_keywords	ssma.access.general.f1

SQL Server Migration Assistant for Access (AccessToSQL)

SQL Server Migration Assistant (SSMA) for Access is a tool for migrating databases from [!INCLUDE msCoName] Access versions 97 through 2010, to [!INCLUDE sssql11-md] through [!INCLUDE sssql25-md] on Windows and Linux, or [!INCLUDE ssazure-sqldb]. SSMA for Access converts Access database objects to [!INCLUDE ssNoVersion] or Azure SQL objects, loads those objects into [!INCLUDE ssNoVersion] or Azure SQL, and then migrates data from Access to [!INCLUDE ssNoVersion] or Azure SQL.

This documentation introduces you to SSMA for Access and provides step-by-step instructions for migrating Access databases to [!INCLUDE ssNoVersion] or Azure SQL Database and information about issues that might occur after migration.

Contents

Article	Description
What's new in SSMA for Access	Lists the changes to SSMA releases.
Install SQL Server Migration Assistant for Access	Lists the prerequisites for installing SSMA, the procedure for installing and licensing SSMA, and a link to the latest version.
Get started with SQL Server Migration Assistant for Access	Introduces SSMA and its user interface.
Prepare Access databases for migration	Describes how to prepare your Access databases for conversion to [!INCLUDE ssNoVersion] or [!INCLUDE ssazure-sqldb].
Migrate Access databases to SQL Server and Azure SQL	Provides an overview of the conversion process and detailed information about each step in the process.
Link Access applications to SQL Server and Azure SQL	Describes how to use your existing Access applications with [!INCLUDE ssNoVersion].
User interface reference	Contains documentation for SSMA dialog boxes.
Work with SSMA Console	Contains documentation on the SSMA Console application.
SQL Server Migration Assistant	Provides information about getting more assistance.