Access and QuickBooks

[AngelSpeaks]

Has anyone connected QuickBooks files to Access? If so, what did you use. I have Access 2019 and QuickBooks Accountant 2013. It looks like I would have to purchase an ODBC driver.

Thanks

 

[The_Doc_Man]

Connect to QuickBooks Online from Microsoft Office

Work with QuickBooks Online data in your Microsoft Office applications.

www.easysoft.com

Here's a starting point. This might lead to something useful. Since I don't use QB, I can only take as far as the web search results.

 

[AngelSpeaks]

Connect to QuickBooks Online from Microsoft Office

Work with QuickBooks Online data in your Microsoft Office applications.

www.easysoft.com

Here's a starting point. This might lead to something useful. Since I don't use QB, I can only take as far as the web search results.

Thanks. That's for QBO. I don't know why it doesn't work for QBD.

 

[AngelSpeaks]

Actually they do have a QBD version. You have to search their site. It's 250 pounds per year.

 

[GPGeorge]

Has anyone connected QuickBooks files to Access? If so, what did you use. I have Access 2019 and QuickBooks Accountant 2013. It looks like I would have to purchase an ODBC driver.

Thanks

I know a few people who have connected Access to QuickBooks, although I don't use QuickBooks. The issue is going to be the driver, as you've found. I suppose you could get trial versions of one or two to try out and see which is a good fit for your needs.

If you want to hire a consultant who works with Access and QuickBooks to help you get started, that might also be a possibility. On the other hand, once you get a connector, the folks here could probably help you work through the issues.

 

[Pat Hartman]

I would never use the online version of any software for data that should always be within my control. It's been a long time but I have used the QB driver to access the desktop version. QB also offers imports/exports so you can use batch transfers for some things. I don't know if QB still offers a desktop version. If it does, there will be an ODBC driver for it also.

 

[AngelSpeaks]

I know a few people who have connected Access to QuickBooks, although I don't use QuickBooks. The issue is going to be the driver, as you've found. I suppose you could get trial versions of one or two to try out and see which is a good fit for your needs.

If you want to hire a consultant who works with Access and QuickBooks to help you get started, that might also be a possibility. On the other hand, once you get a connector, the folks here could probably help you work through the issues.

Thanks George