Exporting multiple tables to create one text file

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

Is it possible to export mutilple tables of varied record length to form one
text file?

I have a situation where I need to export 3 tables whose record length are
different. Table 1 has one record, table 2 has multiple records and table 3
has one record. So when exported the number of records in table 1, 2 and 3
will equal to the number of records in the text file.

Is this possible?
 
Can you use a UNION query, with a sorting field for each subquery, to
combine the table's records together? In other words, do the records from
all three tables have the same number of fields and the same datatypes for
those fields? Or are you essentially wanting to include header and footer
records in the text file?
 
What is the answer about "header" and "footer" records? Can you post the
datatype of each field from the three tables (list fields in order they
would be exported into text file).
 
If I understood the question, I need to include a Header and Trailer record
into the text /data file.
 
Back
Top