Updating split tables

  • Thread starter Thread starter Scruff57
  • Start date Start date
S

Scruff57

I imported data from an Excel spreadsheet and then ran the analyzer which split the table into 3 other tables. When I need to update the data with newer data (daily reports) do I add the new data to the old table (before split) or to the new split table, and will it update properly?

example:
Excel spreadsheet
Date - Employee Name - Supervisor - stat1 - stat2 - stat 3

Imported Access Table (before Split)
date - emplName - supv - stat1 - stat2 - stat3

Access table after split
Table1
emplName
Table2
Supv
Table3
date - stat1 - stat2 - stat3 - Table1 link - Table2 link

If I update from the Excel spreadsheet into the new table, will the split tables also be updated (if a new supv was included in the new data for instance)
 
I don't think having Stat1, Stat2, Stat3 is a properly normalized table.
Imports from Excel should come to a temporary table. From there, you can
append to other tables as needed.

--
Duane Hookom
MS Access MVP


I imported data from an Excel spreadsheet and then ran the analyzer which
split the table into 3 other tables. When I need to update the data with
newer data (daily reports) do I add the new data to the old table (before
split) or to the new split table, and will it update properly?

example:
Excel spreadsheet
Date - Employee Name - Supervisor - stat1 - stat2 - stat 3

Imported Access Table (before Split)
date - emplName - supv - stat1 - stat2 - stat3

Access table after split
Table1
emplName
Table2
Supv
Table3
date - stat1 - stat2 - stat3 - Table1 link - Table2 link

If I update from the Excel spreadsheet into the new table, will the split
tables also be updated (if a new supv was included in the new data for
instance)
 
Back
Top