471,852 Members | 1,413 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,852 software developers and data experts.

multiple tables - combine data - export to excel

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
3 9484

"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
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

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.

Similar topics

NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by
aboka
reply views Thread by aboka | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.