.iif (Quickbooks) Format

[shadow9449]

Does anyone know of a module that will take the results of an Access query and convert them for export into a .iif file that can easily be imported into Quickbooks?

I would imagine that if someone developed something like this, that it would be very useful to any Access developer who creates applications that involve invoicing.

Thanks in advance

SHADOW

 

[namliam]

What is the layout of an iif file? Maybe you can create it using the "normal" text export?

 

[shadow9449]

What is the layout of an iif file? Maybe you can create it using the "normal" text export?

Hallo, Namliam

Aangenaam.

The layout is actually a text export, but it has the column headings preceded by an exclamation mark and some other data definition in each row. I'm sure that I could develop something that iteratively reads the query, and inserts the appropriate data while outputting each line to a text file. I was just wondering if anyone has seen a function that has been developed (and tested!) for this purpose.

Tot later.

SHADOW

 

[namliam]

Morge Shadow...

Seeing as I didnt even know what the layout was, you can guess that I most certainlly havent.... Sorry...

I did find some seemingly intresting links on Google

Succes...

 

[shadow9449]

Morge Shadow...

Seeing as I didnt even know what the layout was, you can guess that I most certainlly havent.... Sorry...

I did find some seemingly intresting links on Google

Succes...

A bit of digging around shows that Quickbooks actually is trying to steer away from .iif in favour of using their XML-based SDK. Their SDK has some VB samples so it shouldn't be too hard to figure out. I'll probably play with it one day. My original post was based on the probability that someone has created an export feature for Access/VB/VBA.

Dank je en tot ziens.

SHADOW

 

[shadow9449]

I was in .iif hell a few weeks ago. That's when I discovered how buggy Quickbooks is. It was the first time that I'd tried to do more than a simple customer/vendor import. The documentation for the .iif formats is inconsistant and QB simply ignores some fields on input that the .iif documentation says it will import. Many fields simply cannot be input with .iif. For example, the employee file input will not take BirthDate, HireDate, or Termination date! How stupid is that?

I found several products that will create .iif files. Just use Google to find them. I didn't purchase any or try them since what I was doing was a one time thing.

I have no experience with Quickbooks, and I don't expect in the near term to become familiar. I just know that for any application that does invoicing (like many of my Access apps) there is a "demand" to get the invoices into Quickbooks so the user can run their business they way that they are used to.

Products that create .iif sound interesting, but I am looking for some code that will turn an Access query into one and export it.

SHADOW