Copy Data Question

a while back i had to take data from a spreadsheet
(*.ods, openoffice) and copy it into a table. i
figured it out and i remember posting what i did on
here - so time to go find it so i can do it again.
;-)

however, this time i have a different situation. i've
hand entered 100+ assemblies.

i have a list of ~1,000 assemblies that need to be
entered.

how can i add *only* nonexisting entries to my db
tables (iow, if it is one of the 100+ there now, i
don't want to mess with it)?

also, how do i update multiple tables with related
info? do i create a view and then copy to the view?

will that automatically update the tables?

tia...

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com