Exporting Access database to Quickbooks

[MSully]

Run time error "3044"

"c:\Program Files\Intuit\QuickBooks Pro\" is not a valid path.

I also get the message that A_Import.iif is READ Only.

THis program originally worked fine when the the OS was Win '98 and Access '97,
the problem began when I upgraded to XP and office 2003.



DoCmd.TransferText acExportDelim, , "Quickbooks_Transaction_Table Query", "c:\Program Files\Intuit\QuickBooks Pro\A_Import.iif"

 

[Douglas J. Steele]

By default, Access limits what extensions you can use to .txt, .csv, .tab,
..asc, .htm and .html

While the following KB articles only refer to importing text files, the same
is true for exporting:

http://support.microsoft.com/?id=245407
http://support.microsoft.com/?id=306144

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Run time error "3044"

"c:\Program Files\Intuit\QuickBooks Pro\" is not a valid path.

I also get the message that A_Import.iif is READ Only.

THis program originally worked fine when the the OS was Win '98 and Access '97,
the problem began when I upgraded to XP and office 2003.



DoCmd.TransferText acExportDelim, , "Quickbooks_Transaction_Table Query",

"c:\Program Files\Intuit\QuickBooks Pro\A_Import.iif"