SQL insert or update

Currently i use

Please Login or Register  to view this content.

to insert data into a table, the only problem is that when i update the table from my excel worksheet it creates duplicate files

if i use update it will not create new entries where they currently do not exist..

i need a overwrite command that also creates a new record where an old is not found!

can i use a update where (blablabla) and if these conditions are not met then insert?


thanks guys,


Jonathan

i had thought about that, however the input will only be for a few fields in a record.. if i delete the record, then i will lose the data input from other sources!

also don't i have to run an append query from access, not excel?

i think what i want is

Please Login or Register  to view this content.

and when this does not find anything to update

Please Login or Register  to view this content.

so something like this:

Please Login or Register  to view this content.

or this maybe?

Please Login or Register  to view this content.

but these all throw errors