cancel
Showing results for 
Search instead for 
Did you mean: 
Fortuna7
Level 1

.iif file creation from MS Access

Hello All,

Happy 2020!!

I was wondering if any of you had already done what I am attempting to do which would save me some programming time. I have a .iif file which loads information into QuickBooks. What I need to do is create that exact same file from Microsoft Access 2016. If someone has already done this, and is willing to share their code, it would save me some time. Having a sample of how to generate the heading line (e.g. !CUST..... and !TRNS/!SPL) and pulling data for each would be great. I basically need to create a TAB delimited file. I have the SQL knowledge and can share that in return.

Any information is much appreciated!

All the best in the New Year,

Fortuna7

3 Comments 3
JasroV
QuickBooks Team

.iif file creation from MS Access

Hi there, @Fortuna7.

 

You can download our QuickBooks IIF import tool kit for reference in creating an .IIF file. Our IIF import tools contains the following components that can guide you through the process:

  • IIF Import Manual: That outlines common .iif best practices.
  • IIF Header Help: The column headings used to import list data.
  • IIF Example Files: A folder that contains version-specific .iif transaction examples.

To install our IIF import kit:

  1. Download our IIF import kit.
  2. Click Save to download the IIF import kit to your Windows desktop.
  3. Use Winzip to extract the contents of the downloaded file.
  4. Open the IIF Import Kit to view its contents.

Here's an article you can read for more details and learn more about the .IIF import kit: IIF Overview: import kit, sample files, and headers

 

Then in case you want to export your QuickBooks Desktop (QBDT) data to MS Excel files, you can refer to this article for the detailed steps: Import or export MS Excel files.

 

Let me know if you have other concerns with your QBDT by leaving a comment below. I'd be happy to help.

Fortuna7
Level 1

.iif file creation from MS Access

Thanks so much for the quick response. I have downloaded the kit and read all the documentation and familiarized myself with the samples. Was just wondering if anyone else had written anything from MS Access.

Anonymous
Not applicable

.iif file creation from MS Access

Hi there, Fortuna7.

 

It is great to see that our prompt support made you happy. 

 

We currently don't support Microsoft Access. What I can do is to personally send it in as feedback to our product engineers. I'll let them know about adding the MS Access as one of our software compatibles. 

 

You may refer to the links below to view the system requirements for the your desktop version:

Let us know if you have any questions about importing IIF files. We are here for you. 

Need to get in touch?

Contact us