Exporting data to multiple text files

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

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
 
more information that might be useful :) using access 2003
files out put should not be qualified with quotes but should be "|" deliniated

thanks Murray
 
Back
Top