How to export Access data using QODBC

F

FJ Questioner

I have a very few data fields in Access that I want to be able to dump into
my quickbooks system on a batch basis. I've obtained the QODBC driver which
enables me to link my Quickbooks tables into Access. However, I don't have
a clear idea of how I get the data from my queries into the proper QB table
fields.

1 line of The Query output is as follows:

DiscFees ConsFee Rebate Reserves DateClosed Company
-20 -10 -6947.2 6977.2 4/3/2006 XYZ Corp.


The .iif format for exporting this query line to QB would be:

!TRNS TRNSTYPE DATE ACCNT NAME AMOUNT
!SPL TRNSTYPE DATE ACCNT NAME AMOUNT
!ENDTRNS
TRNS GENERAL JOURNAL 4/3/2006 Reserves XYZ Corp. 6977.2
SPL GENERAL JOURNAL 4/3/2006 DiscFees XYZ Corp. -20
SPL GENERAL JOURNAL 4/3/2006 Rebate XYZ Corp. -6947.2
SPL GENERAL JOURNAL 4/3/2006 ConsFee XYZ Corp. -10
ENDTRNS


You can see that my needs are extremely simple. However, if you can give me
any guidance as to how I'd physically get the query records into the
appropriate QB fields I'd appreciate it. Also, I' don't want them linked
real-time. I want to transfer the data on a batch basis.

Thanks in advance for any guidance you can give.
 
D

Douglas J. Steele

Was there no documentation that came with the QODBC driver?

What you're asking sounds as though it's a Quickbooks issue, not an Access
one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top