|
Posted by Andrew J. Kelly on 01/27/07 03:08
Your best bet is to import the addresses using DTS or SSIS and then doing an
update join.
--
Andrew J. Kelly SQL MVP
"Chris" <cjscully@gmail.com> wrote in message
news:1169857420.008804.271640@l53g2000cwa.googlegroups.com...
>I got got a pile of bad email addresses to update in our SQL database.
> I know how to do this for individual records using the update command.
> Is there a way to execute an update using the list of addresses in an
> excel spreadsheet or some other form of list? This kind of scripting
> is new territory for me.
>
Navigation:
[Reply to this message]
|