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

multiple tables - combine data - export to excel

P: n/a
Hi,

I have a 3 table database.

1 parent
1 child
1 child of child

I would like to get the data into excel as 1 sheet (similar to a
grouped report).

ex:
Row parent data
Row(s) associated child data
Row(s) associated child of child

etc......

I am relatively new to access and am using 'The Missing Manual' (which
I really like), but I'm stuck.

Thank you for your help.
David

Aug 6 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"yovation" <yo******@gmail.comwrote in message
news:11*********************@e16g2000pri.googlegro ups.com...
Hi,

I have a 3 table database.

1 parent
1 child
1 child of child

I would like to get the data into excel as 1 sheet (similar to a
grouped report).
The simplest way to get something from Access into Excel similar to a
grouped Report is (perhaps not surprisingly) create a grouped Report, then
Export that to Excel. That is, let Access do the work for you.

You can

* create the Query on which to base the Report using the Query Builder,
then
create the Report using the Wizard, then
* modify the design to remove everything from the Report Header, Page
Header, and Page Footer, then
* Preview the Report, then
* File | Export, and choose Excel from the Save As options.

The Excel sheet will still have the Field Names as column headings, even
though they aren't visible on the Report, but it's easy to delete that row
from the Excel sheet if you don't want it.

Larry Linson
Microsoft Access MVP
Aug 6 '07 #2

P: n/a
Larry,

I created the report with no problem. (not using the Query). When I
preview the report, the option to export as Excel Spreadsheet is not
available.

Will using the Query to create the report make the difference?

* create the Query on which to base the Report using the Query Builder,
then
create the Report using the Wizard, then
* modify the design to remove everything from the Report Header, Page
Header, and Page Footer, then
* Preview the Report, then
* File | Export, and choose Excel from the Save As options.

The Excel sheet will still have the Field Names as column headings, even
though they aren't visible on the Report, but it's easy to delete that row
from the Excel sheet if you don't want it.

Larry Linson
Microsoft Access MVP
Aug 6 '07 #3

P: n/a

Thank you Larry,

Turns out my report isn't displaying all the data the way I need it
to. So I'm going to have to take a step back and figure that out
before I export.

* create the Query on which to base the Report using the Query Builder,
then
create the Report using the Wizard, then
* modify the design to remove everything from the Report Header, Page
Header, and Page Footer, then
* Preview the Report, then
* File | Export, and choose Excel from the Save As options.

The Excel sheet will still have the Field Names as column headings, even
though they aren't visible on the Report, but it's easy to delete that row
from the Excel sheet if you don't want it.

Larry Linson
Microsoft Access MVP

Aug 6 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.