Making a Quicbooks IIf from Access

  • Thread starter Thread starter SAC
  • Start date Start date
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
(e-mail address removed)
 
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.
 
Back
Top