Exporting to Text in Append Mode

M

marty

You cannot append using the TransferText Method. You
will have to use OpenAsTextStream method. I use this
method and it works great. Even files that have in
excess of a thousand records export very quickly. For
more information on OpenAsTextStream see Access help.

Marty
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Spec Problem 1
VBA - exporting serial letters to single documents 0
Importing a Tab Delimited File. 4
Exporting a text file WITHOUT the field names (header row) 3
Mixed exporting 2
Exporting data to txt 1
Exporting and appending to txt file 4
too many transferText operations kills export functionality 7

Top