How to Integrate Google Sheets with an MS Access Database



Guide

  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.

🚀

Create your first interactive demo in minutes

No credit card required • Start building today

Start free

    This website uses cookies to enhance the user experience.

    AcceptDecline