TransferText?

[jason.gyetko]

I am exporting a table using the TransferTextMethod:


DoCmd.TransferText acExportDelim, "File Specification Name",
"Table/Query Name", "Path"


This works fine for exporting the extire table, but it overwrites the
output file each time it is run. Is there a way to append it to the
file instead?


Is there also a way to have it write the file one line at a time so I
can do some edit checking on each record. This is not as big of a deal



as I can just run something prior to the export that checks the
records. Or if I have to, rather than using the TransferText, I can
accomplish this by looping through my recordset and appending it to my
file using the Open file & Print options, but this way does not put
Text fields in "".


Thanks.

 

[Jeff C]

Try changing the name of your destination table in your transfertest line.
Then afterward use an update or append query taking your new data to the old
table. By outer joining your tables in an append query you can include all
your new records and just the old records that still exist. Doug Steele has
an article in his website called doing two things at once from an article he
wrote explaining in detail what you want to do.