Access Invoice Query to export to excel and import into Quickbooks .IIF Format

  • Thread starter Thread starter Rich DeGray
  • Start date Start date
R

Rich DeGray

I need to come up with a make Invoice table qry to export into excel in the
Quickbooks IIF format. I have been goofing around with this for a week. I
think I need help.

Thank
Rich
 
I need to come up with a make Invoice table qry to export into excel in the
Quickbooks IIF format. I have been goofing around with this for a week. I
think I need help.

Thank
Rich
Click to expand...

Can't QB read Excel? The version I got a demo of does. you should be
able to create a query in Access and then use either
TransferSpreadsheet or one of the Excel automation routines at
www.mvps.org/access to transfer the data to Excel (if you are using a
template). then QB should be able to read it from there. does that
work?
 
Back
Top