Append Export to Text Doc

[Rick25]

I am having trouble with my database sizing out because of an append table with historical months' data. I have set up a process to automatically export the new months' data to a text file. I would like to make another text file that is more like a log file that appends any new month's data to the bottom. Any ideas on how to do this in VBA? Should I try to do it with a batch file external to Access and run the batch using AppActivate?

Thanks,

Rick

 

[Dugantrain]

You should be able to set a linked table to the text file within Access and then write an Append Query to Append to that table.

 

[Rick25]

Easy. Sorry about that one. That is quite obvious. Thanks for saving me some time!