[AccessD] Access Export to Excel AND Quickbooks

On 24 Jun 2004 at 9:50, Keith Williamson wrote:

> 
> This is what I am trying to do; export from the report.  I want to use the
> report to setup a template for importing into Quickbooks.  I need the header
> area of the report for additional information in the template.  If I have to
> export from the query....then I first need to import into Excel, and add the
> header info....prior to importing to Quickbooks.  So, it is costing me an
> additional step, which I am trying to avoid.
> 
> Maybe I can use a docmd.transfer  ??  Or some other method of directly
> exporting the report with an .iif  extension, that I can immediately import
> into Quickbooks.  

That's the best way. It gives you total control over the file format.

> Of course, this would require the export process to
> maintain the code as the full text, and not truncate the zeros.
> 

I haven't done it for Quickbooks, but I've done this sort of thing for a number of other accounting packages.
Sounds  like you need a header row and a series of datarows in a space, tab or comma delimited file?
If so, the easiest solution by far is to use standaard file IO.

Open an QBooks import file for Output
Build and print# the header row(s)
Open the query as a recordset
Do
  Build a data row using Format$, RSet, Mid$ etc
  Print# the data row
  Read next row
Loop until EOF
Close the QBooks file 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.