Access 2003: Append table data to a text file with code - VBA
Posted on 2008-06-19
I need to append data from a table to a text file that has already been created with a DoCmd method. Here is that
DoCmd.TransferText acExportFixed, "EXPORT_TABLE_Export_Specification", "EXPORT_TABLE", "C:IA_Subscriptions\Test.txt"
It works fine but now I want another line that appends data from another table to the text file. Any help is greatly appreciated.