multiple tables - combine data - export to excel

[yovation]

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

[Larry Linson]

"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

[yovation]

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

[yovation]

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