sql server data mining: how to? append new records and delete missing -- sql server data mining

how to? append new records and delete missing

Steve Chambers
9/18/2003 6:54:15 AM

sql server data mining:

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

Re: how to? append new records and delete missing

Sue Hoegemeier
9/18/2003 9:09:15 PM

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"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server data mining group.