By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 956 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Access to Excel

P: 6
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.
Jul 27 '07 #1
Share this Question
Share on Google+
1 Reply


Boxcar74
P: 42
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 "TransferSpreadsheet" 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/thre...ml#post2682532

Good Luck!!

-- Boxcar
Jul 27 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.