extract transaction data from quickbooks

[supmktg]

I'm trying to extract invoice and payment transaction data from a very old version of quickbooks. This very old version allows for the export of customer and item lists to .iif format which I can view in Excel. However, there is no method of exporting transactions. All of my searches for how to extract the data have come up empty.

I am pretty sure that I once found a post relating to looping through the file line by line and converting the data using vba. I can't find that post anywhere either.

Is anyone familiar with a method of extracting data from a quickbook .qbw file. I'm willing to do a fair amount of manual parsing if I have to, but I need to get to the data first.

Thanks,
Sup

 

[Guus2005]

Hi Sup,

You said a quickbook can be viewed/opened by Excel? If so you can start an Excel object, open the quickbook file and browse through every line.
In doing so you can save the file as a text file or an Excel file or you can use VBA to export the columns you need into a text file.

Can you post a sample quickbook file?

HTH

 

[supmktg]

Hi Guus,

Actually it can't really be opened in Excel. If you open it in Excel (or in any text editor), all you see is weird random characters with a customer name here and a item description there and other bits of random field data scattered throughout the file which is mostly gibberish.

In researching (a while ago) some sort of pattern to be used for converting the gibberish into usable tables with the existing data that is obviously there, I thought I remembered seeing someone that had figured it out and built a vba function to do that. I have searched and searched and can't find that function or any other way to get to data.

I did, however, discover a way to create some custom reports which I can then print to a .prn file that I can open as text. Although some of the fields are not available to include in these reports, a majority of what I am looking for is basically there.

If you had built or seen a function for parsing a quickbooks file that would have been great. At this point I have most of what I need and it will probably take me a lot less time and effort to recreate what is missing than the time it would take you to analyze, let alone build a function to parse this encrypted file.

I've uploaded the quickbooks sample file in case you are interested in seeing the structure.

Thanks,
Sup

 

[Guus2005]

Hi Sup,

I googled "Quickbooks VBA" and here are the winners:

http://developer.intuit.com/
to download the SDK and/or get more information.

Step by step:
http://support.flexquarters.com/esu...le/View/2571/0/using-quickbooks-data-with-vba

Nice piece of sample code:
http://www.experts-exchange.com/art...-Transactions-Without-Opening-QuickBooks.html

HTH

 

[supmktg]

Hi Guus,

Thank you very much for this info!

Sup