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

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
 
P

pietlinden

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2
how do you export excel files to Quickbooks Simple edition 1
Access to quickbooks - looking for consulting help 4
QuickBooks export to Excel 1
How to Save Data Retrieved from Pass Thru Query 4
I need to create a file in the .iif format from Excel 2
IIF function with * 7
IIf Problem 5

Top