Update Suggestions Please

G

Golfinray

I have built a database and have built the tables from Excel spreadsheets. I
did not use link for some work-related reasons, I simply Imported the tables
and assigned primary keys. I then built my queries and forms as needed and
everything works fine. My question is, now I would like to update (say every
two weeks or so) those tables from any new data entered in those
spreadsheets. I have 12 spreadsheets and 12 tables. Since I am unfamilier
with this topic, would it be better to build update queries OR would it be
better to Link the spreadsheets and then run Union queries periodically, or
is there a better method than either of these? I really can't put the data of
all 12 tables into one table because they are so completely unrelated.
Thanks!!!
 
J

Jeff Boyce

Importing Excel-structured data directly into Access tables means you are
trying to use Access' relationally-oriented features and functions, but
feeding it 'sheet data. You will find that you have to work very hard to do
things that are actually quite simple, if only your data was well
normalized.

Any chance you could first import the Excel data as "temp" or "raw" data,
then use queries to parse it into a more permanent, well-normalized
structure?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top