VB and Access question....

[Dan0331]

Hi Everyone,

I'm working on a VBA project that requires me to export the data in two seperate tables to one text file outside of the database. I have no problem exporting the first, but once the second goes, it overwrites the first. I've tried to export the data from both at one time, but to no avail.

Here's what I'm doing. I've got to tell you as I cannot keep the code from "wrapping" as the lines are longer than the box you type in.

I've got 'Cfilename2' and 'Cfilename3' dimmed as strings. I'm assigning the values of each to a test file on my HD. I run two "Make Table Queries" to pull the appropriate information from two other tables. I then use the DoCmd.TransferText acExportDelim once on each of the files to send them to the text files mentioned above. I include the Export Specifications for each of the files, but they first continues to be overwritten by the last.

Any suggestions?

Thanks!

[RogerH]

there may be more sophisticated solutions but how about writing file1.txt and file2.txt and then using

shell "copy file1.txt+file2.txt file3.txt"

should work

Roger