Question Merge Multiple Text Files

[DBFIN]

How can I merge the data from three text files into one text file ? I have three separate queries that each have completely different fields and field formats. I export each of these queries to three separate text files. How can I merge all records into one text file? I need a simple solution using standardized MS Access functions, macros or expressions, since I won't be utilizing any hard-coded language to merge the data.

 

[Pat Hartman]

If the tables all had identical column structures you could use a union query to merge them into the same recordset. When the tables have different structures, you can't use a union query.

If the data will be exported as blobs, you can write a query for each table that concatenates all the columns into a single text column. You could then union the blob columns to export the merged file.