|
|
Posted by Steve on 01/27/07 02:32
If your Excel file has a column matching the the Primary Key of the
database table, in addition to the email address column, you can use
DTS(2000) or SSIS(2005) to import it into a table and use an INNER JOIN
in you UPDATE.
On Jan 26, 4:23 pm, "Chris" <cjscu...@gmail.com> wrote:
> 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]
|