# How to Integrate Google Sheets with an MS Access Database

> To integrate Google Sheets with an MS Access database, navigate to External Data in the top menu bar, select ODBC Database under Import & Link, and choose your data source and destination. Next, click Machine Data Source, tap New, specify the data type, select the Google Sheets driver, review connection details, and provide the required information to finish.

Canonical: https://livedemo.ai/tutorials/how-to-integrate-google-sheets-with-an-ms-access-database/
Apps: Google
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a4290ab56e05a00feb42b/preview?step=1

## Steps

1. Inside the main dashboard of your MS Access database, head over to the top menu bar and click 'External Data'.
2. Go over the options under the Import & Link section and then select 'ODBC Database'.
3. After that, select your preferred data source and destination. Once it's all set, go ahead and click 'OK' to continue.
4. Click the 'Machine Data Source' tab.
5. Next, tap 'New' to establish the connection between Google Sheets and your MS Access database.
6. Following that, specify the type of data you wish to use and then click 'Next'.
7. Choose the specific Google Sheets driver you want to use, then tap 'Next' to proceed.
8. Once done, review the connection details and click 'Finish'.
9. Finally, provide all the required details and then click 'OK' to enable the integration of your MS Access database with Google Sheets.