How to export Access data using QODBC

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top