Import several tables & link

[Martin ©¿©¬]

HI
I've just commenced the access learning curve
I hope to import/create 14 tables (from Excel)
How do i add and link the 14 tables to 1 new table

I want to be able to edit/view/print each of the 14 tables in their
own right - but also have 1 cumulative table of the 14 combined
(I hope this makes sense)

Is it also possible to have changes in the 1 big table reflected in
one or more of the 14 tables too ??

Martin
©¿©¬

 

[Guest]

HI

I've just commenced the access learning curve
I hope to import/create 14 tables (from Excel)
How do i add and link the 14 tables to 1 new table

Use the import wizard in Access to import from Excel.

I want to be able to edit/view/print each of the 14 tables in their
own right - but also have 1 cumulative table of the 14 combined
(I hope this makes sense)

Basically you would have a query to bring them all together in one view.
How to write the query depends on how the 14 tables are related to one
another.

You don't want another actual table as you would have duplicate data in two
locations.

Is it also possible to have changes in the 1 big table reflected in
one or more of the 14 tables too ??

Unless all 14 tables are related 1-to-1 the query will most likely not be
updateable.

-Steve Huff