We have a challenge and I am not sure how to address this one.
The table we are wanting to update (modify) is the SY04906 -- first points if you know without looking it up -- that this is the Vendor Email Option window in which you can set the values for a vendor with respect to sending emails.
The switches are simple - Enable ( Yes / No ) and such - however we encounter a challenge with the email addresses
We have collected - in Excel - all the new / or updated email address for vendors we want to look at. However, when we attempt to import the data to the table all but 10 or 15 of them fail. When looking at the data in SQL we see that in all of the cases there was an email address already there.
We have a list of over 300 vendors that we want to update. Not only the SY04906 but the SY01200 and a couple of others related to email address. All need to be done by Table Import. Our challenge really is that we are not confident in the SQL side enough that we would write a script, look at the values in the excel table and import them. I am crashing the SQL books right now to figure out how to take the CSV file and get it into a SQL table. From their I am thinking I would do an update where the new email would be selected from the 'imported table'
Anyone got a better suggestion? Right now we might consider anything.
