Access to Excel

[ANDRE726]

I have an Access table with several thousand records. The key field is region. There are approimately 10 regions. I would like to generate one spreadsheet for each region. Each spreadsheet should have a unique name i.e. Myspreadsheet01 , Myspreadsheet02 , etc. How can I automate this process? Should regions increase or decrease to 8 or 12, I do not want to have to modify the code. Is this possible?
Thanks.

[Boxcar74]

It seem too simple of an answer but:

If you can have a query for each region.

You can create a simple macro in the macro section no VBA needed.

Have the Macro action be "TransferSpread sheet" set it to export but the query name in the table field, punt in the path of where you want it to be exported to.

I'm not sure if this is what because you would have to do this for each region and you would end up with 10 excel files (one for each region).

To automate this use can use the Windows Scheduler and a batch file.

I posted info on have to do that here:

http://www.thescripts.com/forum/threadedpost2682532.html#post2682532

Good Luck!!

-- Boxcar