Here is my problem.
I have a table in Access that has mics. vendors information.
I want to create misc. Excel files based on the Vendor Name.
Anotherwords, I want to somehow read the table, and create an Excel file for each Vendor.
The only way I presently know how to do this would be to have one query with selection logic for each vendor.
IE: 500 vendors would take 500 queries.
I need one program to create the 500 Excel files....
Anyone that knows how to do this with Access commands, or Access VB
would be greatly appreciated. I am no VB
expert, but if someone has code, I can fake it...