Append Access 2003 Report to Text File Using VBA

[ChiSoxFan]

I'm new to using VBA for Access 2003 and need some help.

I'm currently creating a text file (test.txt) and using the Print command to add "header" information.

Once that is complete, I need to append a report (rptTest) to the existing text file (test.txt).

I've tried: DoCmd.OutputTo acOutputReport, rptTest, acFormatTXT, test.txt

However, this overwrites all the "header" information.

Please let me know what I'm doing wrong.

Thanks,
ChiSoxFan

 

[Remou]

You will have to output the report to a second file and then use, say, the FileSystemObject to read the report into the header file.

 

[ChiSoxFan]

Figured this out.

Thanks Remou for the help.

ChiSoxFan