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!!!

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

"Golfinray" <Golfinray@discussions.microsoft.com> wrote in message 
news:85DA73FB-C5FF-43BB-BA3F-3D442E5ACCAE@microsoft.com...
>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!!!