update tables?

[robertsdgm]

I have one large table from Excel which I "imported" into Access. Thereupon, I then I ran analyze table on this "large" table and broke it all up into a true RDBMS.
My question is..
Now I have made updates to this large Excel table. How do inturn update all the subsequent little tables automatically? Do I have to write tons of update queries?
thks!
Dan

 

[fredk]

What kind of "changes" are you talking about to update the data? Hopefully, you linked all of the tables together - Just need a little more detail.

Fred

 

[robertsdgm]

What I have done..is imported from Excel a worksheet named "dan"
Then from here within Access I ran analyze table on "dan" and in turn broke up the orginal "dan" table into dan1,dan2 and dan3 tables within access with relationships btw these last three tables. Now at this point access renames the original dan table to dan-old..
Now..at the Excel end I hvae more data added as well as some changed...So how would I incorporate this improved/new data into my access schema..
Hope this helps!
thks
Dan

 

[fredk]

I am at a disatvantage because I am not sure how the fields are linked. Depending on how the data is linked, you may be able to import the new excel file into a seperate table into access - then run an append query to move the data from this new table into the tables that are now set up (dan1, dan2, dan3)

But, because you have some of the original data changed in the new excel file, I would probably say to start over from scratch -

Fred