Making a Quicbooks IIf from Access

B

bob

Yes - it can be done since a Quickbooks iif file is a fixed field length
text file with a header record and a footer record.

The data section itself is pretty easy since Access allows that to be done
routinely - but the header and footer are more of a problem (they require
code).

Additionally, its hard to find the info re: the proper structure for
Quickbooks ..you can get samples from Intuit but it takes a lot of
experimentation to actually use them properly ..

See www.bbg-enterprises.com for an example of this being done.

Bob Galway
[email protected]
 
G

Gary Miller

Not that it is going to make it any easier for you, but
Quickbooks is now going to qbXML (QuickBooksXML) format and
I understand that they will soon be dropping support for
IIF. Do a google on qbXML.
 
Top