Hello,
I have a master/detail style database. For example,
Master table:
id, name, address
1, jerry, 17 avenue

Detail table:
id, masterID, project, status
1, 1, "caranalysis", "going"

Is there a way to display this kind of master and detail relationship
in a excel spreadsheet?

Cheers,

Jerry

Depending on how many unique ID's you have and what you want to do with the
data, I would keep all the info for one ID on its own worksheet.
But really Access is the way to go with this.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

<(E-Mail Removed)> wrote in message
news:31e7ada9-e4cb-45e0-b6a7-(E-Mail Removed)...
> Hello,
> I have a master/detail style database. For example,
> Master table:
> id, name, address
> 1, jerry, 17 avenue
>
> Detail table:
> id, masterID, project, status
> 1, 1, "caranalysis", "going"
>
> Is there a way to display this kind of master and detail relationship
> in a excel spreadsheet?
>
> Cheers,
>
> Jerry

On 20 Nov, 13:13, "Bernard Liengme" <blien...@stfx.TRUENORTH.ca>
wrote:
> Depending on how many unique ID's you have and what you want to do with the
> data, I would keep all the info for one ID on its own worksheet.
> But really Access is the way to go with this.
> best wishes
> --
> Bernard V Liengme
> Microsoft Excel MVPwww.stfx.ca/people/bliengme
> remove caps from email
>
> <D...@hotmail.com> wrote in message
>
> news:31e7ada9-e4cb-45e0-b6a7-(E-Mail Removed)...
>
> > Hello,
> > I have a master/detail style database. For example,
> > Master table:
> > id, name, address
> > 1, jerry, 17 avenue
>
> > Detail table:
> > id, masterID, project, status
> > 1, 1, "caranalysis", "going"
>
> > Is there a way to display this kind of master and detail relationship
> > in a excel spreadsheet?
>
> > Cheers,
>
> > Jerry

I am doing a project to export a master/detail database to excel (The
client wants it). It is easy to export to excel, but I did not find a
nice way to handle the relationship.

Cheers,

What do you want the final to look like?
id, name, address 1, "caranalysis", "going

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
<(E-Mail Removed)> wrote in message
news:31e7ada9-e4cb-45e0-b6a7-(E-Mail Removed)...
> Hello,
> I have a master/detail style database. For example,
> Master table:
> id, name, address
> 1, jerry, 17 avenue
>
> Detail table:
> id, masterID, project, status
> 1, 1, "caranalysis", "going"
>
> Is there a way to display this kind of master and detail relationship
> in a excel spreadsheet?
>
> Cheers,
>
> Jerry

[Norbert]

Hi,
there is specialized Access add-in named A2EE.mda.
This add-in is doing exactly what you need - it exports data from Access datasheet with subdatasheet (mother table or query with related child table or query) into Excel.
The mother X child structure is preserved after the export to Excel.
The add-in is easy to be found on the Internet.
BR
Norbert