description: Learn how to link your Access tables to the migrated tables so that you can use your existing Access applications with SQL Server or Azure SQL Database.

If you have a legacy MS Access database or like its GUI, then there are ways to boost its abilities by teaming it up with SQL.

How to: MS SQL to MS Access. Microsoft Access provides tools that make it relatively easy to load data from a variety of external data sources and in many different formats.

The Microsoft OLE DB Provider is an SQL tool that enables developers to write code that provides an application with ADO access to an SQL database.

Microsoft Office is more than the sum of its parts—you can link an Excel database table to an Access database, integrating your data and adding value. Here's how.

access-linker will automatically append the Access System Database to the connection string. You have to run Access for the first time to create this file.