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

Access data into many Excel sheets

P: n/a
I have an Access 2003 table that I want to generate into tabbed Excel
2003 workbooks using a button on a form.
The tables would need to overwrite everytime that the button would be
pressed.
Table name: Datatable (data)
Field1: Customer (Bob, Dan, Joe)
Field2: Model (Ace, Cat, San)
Field3: YrMo (2007-01, 2007-02, 2007-03)
What I need is to get them into this format:

Workbook: Bob-Ace.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Bob-Cat.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Bob-San.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Dan-Ace.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Dan-Cat.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Dan-San.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Joe-Ace.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Joe-Cat.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Joe-San.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03
I've tried several methods so far, and I just can't seem to get it
right.

Anyone with some pointers/code?

Oct 8 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Oct 8, 2:29 pm, mwillia...@socal.rr.com wrote:
I have an Access 2003 table that I want to generate into tabbed Excel
2003 workbooks using a button on a form.
The tables would need to overwrite everytime that the button would be
pressed.

Table name: Datatable (data)
Field1: Customer (Bob, Dan, Joe)
Field2: Model (Ace, Cat, San)
Field3: YrMo (2007-01, 2007-02, 2007-03)

What I need is to get them into this format:

Workbook: Bob-Ace.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Bob-Cat.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Bob-San.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Dan-Ace.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Dan-Cat.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Dan-San.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Joe-Ace.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Joe-Cat.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

Workbook: Joe-San.xls
Worksheet tabs: 2007-01, 2007-02, 2007-03

I've tried several methods so far, and I just can't seem to get it
right.

Anyone with some pointers/code?
The TransferSpreadsheet( ) function can do most of this, if not all.

Oct 8 '07 #2

P: n/a
I have tried using that but I can't get it to do the tabs portion.

Oct 8 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.