Ask Your Question
1

Is it possible to use Base to query QuickBooks database with QODBC?

asked 2016-09-22 17:56:00 +0100

kansas_plainsman gravatar image

We are a QB 15 Enterprise Desktop environment and want to do sql queries against the QB company file. Intuit provides a customized ODBC which allows read access to the company file via apps like Access and Excel - but I was wanting to pull data out, and potentially into a Base database. Anyone done this? And is it a reasonable option?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2016-09-23 01:30:16 +0100

Ratslinger gravatar image

updated 2016-09-23 02:08:01 +0100

The QODBC driver will allow Base to connect but all that it provides is read access to its' tables (unless you get the full version). You can do queries and reports, but that is about all.

Since Base only allows one connection at a time, there is no way to store any extracted data into another database. So reading a QB database and writing that information to a another database is not currently possible with Base.

Edit:

As an afterthought, it may be possible to use an intermediate such as TOra or SQL Workbench (and possibly others) to transfer data between databases. I have done this with SQL Workbench connecting two different types of DB's and transferring data. Don't know much about TOra - just some light reading.

If this answers your question please click on the ✔ (upper left area of answer).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-09-22 17:56:00 +0100

Seen: 193 times

Last updated: Sep 23 '16