# How to Integrate a Microsoft Access Database with QuickBooks

> To integrate your Access database with QuickBooks, open the Microsoft database, click External Data, and select ODBC Database. Specify the data source, click Machine Data Source, and create a new connection. Choose your data type and QuickBooks driver, review connection details, and enter required information to finish.

Canonical: https://livedemo.ai/tutorials/how-to-integrate-a-microsoft-access-database-with-quickbooks/
Apps: Microsoft, QuickBooks
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a402bab56e05a00fe836b/preview?step=1

## Steps

1. Inside the main dashboard of your Microsoft Access database, go to the top menu bar and then click 'External Data'.
2. Pick 'ODBC Database' from the available options under Import & Link.
3. Following that, specify your preferred data source and destination. Once done, click 'OK' to proceed.
4. Click the 'Machine Data Source' tab.
5. Subsequently, tap 'New' to create the connection between your MS Access database and QuickBooks.
6. Choose the type of data you wish to use, then tap 'Next'.
7. Choose your preferred QuickBooks driver from the available options and then click 'Next' to keep going.
8. Next, review the connection details and then tap 'Finish'.
9. Finally, provide the required information and then click 'OK' to enable the integration of your MS Access database with QuickBooks.