How do I append to a text file when exporting from Access or Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to export to a text file from an Excel or Access macro.
I need to look to see if that file name already exists, and if it does,
append data to the end of that file, otherwise just write the file.
 
Access's built-in facilities don't allow you to append data to a text file.
Any of these approaches will do it:

A) export your second file in the normal way and then concatenate it to the
existing file (using Dir() to check whether it exists, and Shell() to call
the Windows COPY command to do the actual concatenation.

B) temporarily import the existing file into an Access table, append the new
data, and export it all to a new text file.

C) open a recordset on the data you want to export, open the existing file
using the VBA Open ... For Append ... statement, and use VBA code to write
the new data line by line.
 
Back
Top