Geek Answers Handbook

This allows you to capture SQL tables from a QuickBooks QBM file. Perhaps there is a SQLite database?

This will make it easier to import data for our software if I can export the tables to SQL or CSV or another working format. We often export from QuickBooks and import into our software, and it would be easier and faster if we could just get the QBM client file and then do the rest on our side. We export individual reports to CSV files, but this is a manual process that we would like to replace with the QBM tool with SQL (or CSV files or tab delimited files or another working format).

+4
source share
3 answers

The ODBC driver for QuickBooks is available here . This driver is based on the QuickBooks SDK. Learn more about the SDK here . If you want to create a sophisticated and reliable export utility, you should consider using the SDK directly. This will cause some development resources, but there is no problem using Java with the SDK if you use the XML API directly and not the "QBFC" interface, which only supports .NET, VB6 and VBA.

If, on the other hand, you have a simple export, I would recommend using an ODBC compatible tool like Excel, and forget about writing code. There is a great tool available that will do without ODBC and just do the import and export for you. Definitely what to see.

Finally, if you prefer to use ODBC with Perl or Java, which is certainly possible with the QODBC driver. However, it looks like you need to learn how to access ODBC with Perl or Java, since you have no experience with ODBC. This is not the best way to learn ODBC, as the QODBC driver is a bit unusual.

+1
source

We had a similar requirement in our application and found something called the Quickbooks Data Provider . This is a tool that allows you to retrieve information from QB and access it in the form of SQL tables, just like using SQL Server. This is great because you can manipulate the data the way you want.

With it you can do something like:

QuickBooksConnection cn = new QuickBooksConnection(conString); QuickBooksCommand cmd = new QuickBooksCommand("SELECT * FROM Customers", cn); QuickBooksDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { listBox1.Items.Add(rdr["Id"] + " : " + rdr["Name"]); }

Found it very easy to use and helped a lot to manipulate information.

+1
source

There are ODBC drivers for Quickbooks. I think it even comes with one, but I could be wrong.

0
source

More articles:


All Articles