Hi, I'm have an access db which I regularly import into
SQLServer.
The access db has new records added and some records
taken off so I use the DTS wizard and delete all the
records and then insert the new records.

My current process needs changing as I need to add a
couple of fields to the SQL db and the data in them has
to stay linked to their respective records.
I want to import any new records in the access db into
the sql db and delete any in the sql db that aren't
presant in the updated access db.
Where do I start?
TIA
Steve

Check NOT EXISTS in books online. You can do an insert where
the records in the access table don't exist in the sql table
and do a delete where the records in the sql table don't
exist in the access table. There are several examples on how
to use this in books online.

-Sue

On Thu, 18 Sep 2003 06:54:15 -0700, "Steve Chambers"
<steven.chambers (AT) threerivers (DOT) gov.uk> wrote: