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

Thanks,
Jim

Jim,
I have a suggestion. Why not just instead of Excel file use
Word document? Have it as a mail merge from Access to Word.
John

Hi You got any answers, I need the same. Thanks

You want to create a single Excel file for each vendor record in your database? Yikes. That can be done, but you will need to code that. Are you still looking for this solution? How are you selecting each vendor? Can you post the table structure in Access, and then what you want to see in the Excel files? Also, what naming are you going to use on the Excel files?


mmcdonal

Look it up at: http://wrox.books24x7.com