tables created by Linking an Excel File

[Sarah Wiloby]

Hi Mates

I have a linked access table created from an excel
spreadsheet. Then I used Table Analyze feature in access
to split this and the split created 3 seperate tables.

When the excel spreadsheet is changed the linked table
gets updated but split tables remains unchanged. Is there
a way these split tables to get updated automatically.

Thanks mates in advance for your help.

Sarah W

 

[John Nurick]

Hi Sarah,

The table analyzer is designed for splitting a non-normalised table into
two or more new, normalised tables. This is a one-time process: the new
tables are entirely separate from the old one. The idea is that having
once normalised the data you start using the new tables and delete the
old one.

If you have to retain the link to the spreadsheet, you can't use the
tables created by the analyzer. Instead, set up queries on the linked
table to return the data in the way you need (maybe modelling them on
the structure of the tables created by the analyzer).