Exporting data to txt

D

DaveB

Hi, I have created a Transfer Text macro based on a query to export data from
a form using a Command Button. How can I append the data so that each time a
user uses the Command Button the data from the selected record is appended to
the existing text file rather than overwriting it?
Thanks
 
D

Douglas J. Steele

I don't believe it's possible using TransferText, nor do I think it's
possible using a macro.

I think you'd need to use the Open and Print statements in VBA, and do the
export manually each time.
 

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

Exporting and appending to txt file 4
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Missing info when exporting report to txt file 2
Exporting data to xml file 3
Access Automatically Send a notification email once a record is added 0
How to Create a Macro to Import External Data 0
Export to excel file in Access 1
Append import data to existing record 19

Top