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