1. Home
  2. Point-Of-Sale Software
  3. SQL Statement to remove bad e-mail addy's?

SQL Statement to remove bad e-mail addy's?

Howdy,

I'm looking for help removing bounced and unsubscribed e-mails.

I have a CSV file with all the bad e-mails. I need a compare and remove statement that will delete the e-mail address only from the Customer Table.

Or any other workaround to keep me from doing 400+ manually

thanks

Reply to
confluencekayaks
Loading thread data ...

I would use MS Access to connect to both data sources, join the csv to the customer table on the email field, and then update the emailaddress to a blank string. The sql code would look something like this:

UPDATE temp INNER JOIN dbo_Customer ON temp.email dbo_Customer.EmailAddress SET dbo_Customer.EmailAddress = "";

"c> Howdy,

Reply to
Matt Hurst

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.