Exporting data to multiple text files

[Guest]

I am New to using Access so this might be a simple question to some. How does
one export data to mutiple files based on a variable in the table you are
exporting from?

situation is this:
table X has 5 columns and many thousand rows. the columns are;
store, customer number, article, date sold and sales report

table Y has 5 columns and +- 100 rows. the columns are;
key, type of sale, pay value, sales report and count of transaction

there is a relation built between the two tables on the sales report column.

problem:
how do I generate a text file with each unique sales report from Table Y and
make another text file with all corresponding data from Table X. The
requirement is to have a "header" text file (information from table Y) and a
"data" text file (the information from table X). the files should follow the
naming convention of "salesreport.txt" and "salesreportdat.txt"

any help would greatly be appreciated.

Thanks

Murray

 

[Guest]

more information that might be useful using access 2003
files out put should not be qualified with quotes but should be "|" deliniated

thanks Murray