Setup SQL relationship so that Excel can link 3 tables

[neFAST]

I need to establish a database for 3 measurement devices A, B, C that will generate:

id      id      id    
mesA_1  mesB_1  mesC_1
mesA_2  mesB_2  mesC_2

So I have to create the 3 tables and the relationship between the three id keys.
In the end I want to be able to query the database from Excel to display in a single line the measurements of the 3 devices.

I followed tutorials but most of the time they're for 2 tables and not 3. Basically I set every id key as PRIMARY but then I do not know if the relationship is two-way or not, if must chain the 3 tables or define a master and two childs. In short I'm clueless.

 

[NARAYANK991]

Hi ,

When you talk of tables , do you mean Excel tables or Access tables ?

See the following link for how to use MSQuery to query multiple tables.

http://exceluser.com/formulas/msquery-excel-relational-data.htm

Narayan

 

[Hui]

You may want to have a read of:
http://forum.chandoo.org/threads/how-do-i-consolidate-several-tables-in-one-long-table.2443/
especially the comments

&
http://chandoo.org/wp/2012/04/02/using-excel-as-your-database/
there is a section on SQL towards the bottom