Copy Data Question

[<operationsengineer1(at)yahoo(dot)com>]

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