Exporting data to txt

  • Thread starter Thread starter DaveB
  • Start date Start date
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
 
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.
 
Back
Top