Hi,

Has anyone used OI as a DDE client to Quickbooks ? If so, would you mind advising how it is done, please.

All I want to be able to do is read the data file (only one it seems), and even the use of DLL's may be the way to go ? There are some DLL's in the QBOOKSW directory that appear to be related to data retrieval, however I have had no response from the www.intuit.com site, so possibly there is someone who can help on this one ?

Peter

Hi Peter,

I have never used Quickbooks before so I cannot help on that end. Although I have used OI as a client to VB getting information from a VB form and was successful.

If it's getting data from a table that Quickbook uses then maybe you may think of using ODBC. If it's getting data from a table via a form that Quickbook uses, then you can use DDE in OI to request the information from that form.

Let me know what you plan to do and I can try and help you further.

Blaise.

Blaise,

I am not familar with DDE or ODBC, but for a start the data for Quickbooks is stored in one file as such:

Directory of C:\qbooksw

SAMPLE QBW 994,304 11-10-97 4:08p SAMPLE.QBW

FEBC QBW 653,312 02-18-98 6:54p febc.qbw

and the structure is of course, not like other products I have worked with. When we run Quickbooks, there is no easy way of telling what form is running (I think) so maybe the ODBC method may be the best shot at this stage.

Peter

PS My replies to you may not be as frequent as daily; it's difficult in the Philippines to get a line that isn't noisy.

Hi Peter,

I would say that ODBC would be a good and maybe the best way to get your data from Quickbooks and see it in OpenInsight. Can you find out if they have and ODBC driver for their files? If they do you can very easily get your data into OI.

Let me know what you find out.

Blaise

View this thread on the forum...