sqlquickbooksquickbooks-online

How to query some data out of a QuickBook(.qbw) file?


Situation

Let's say, I want to query only the inventory report.

I've been looking for a tool out there everywhere, I could not find anything that will does exactly what I want.

Can someone get me start on this ? Can anybody at least point me to the right direction ?

I am not exactly sure, if what I am trying to do is possible.


Solution

  • Not a direct answer, but some direction as you requested:

    The QOBDC driver available here (http://qodbc.com) should allow you to access your qbw file like a SQL database and perform queries against it. There is a free trial, but it looks like you'll need to pay $150-$500 to buy this driver if you find that it works and you want to use it long term.

    As for querying a specific report like inventory, I don't know, but there are plenty of tutorials around in the form of blog posts and YouTube videos that should help you figure out how to use QODBC for your purpose.