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.
 
Top