How to Connect an MS Access Database to SQL Server

‍

‍

It is very easy to connect an MS Access database to SQL Server. Here’s a quick tutorial on how to do it:

‍

1. Inside the main dashboard of your MS Access database, head over to the top menu bar and click 'External Data'.
2. Select 'ODBC Database' from the available options under the Import & Link section.
3. Following that, select your preferred data source and destination. Tap 'OK' afterwards to proceed.
4. Click the 'Machine Data Source' tab.
5. Subsequently, tap 'New'.
6. Specify the type of data you wish to use as the source and then click 'Next'.
7. After that, pick 'SQL Server' from the list of options and then tap 'Next'.
8. Check the configuration details, then tap 'Finish'.
9. Once done, head back to the Machine Data Source tab and then select the newly configured SQL Server data source. Tap 'OK' afterwards to continue.
10. Review the configuration details one more time and then click 'OK'.
11. Finally, provide your preferred Data Source Name, Description, and SQL Server. After that, click 'Finish' to save and enable the integration of your MS Access database with SQL Server.