Exporting multiple tables to create one text file

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?
 
K

Ken Snell \(MVP\)

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?
 
K

Ken Snell \(MVP\)

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).
 
K

Ken

If I understood the question, I need to include a Header and Trailer record
into the text /data file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Results of Access 2000 query to text file. 2
Exporting .TAB file 1
Import to several tables in one process 6
Exporting data to multiple text files 1
Access Dcount (multiple criteria) 3
file type export problem 5
How can I Import data from one text file to multiple tables? 1
Data from excel into access then from one to many tables 0

Top