I have a table (dbo.tblPoint) that contain 2 columns (PiPointID and ServerName) that are populated with incorrect values. I have a spread sheet that contain the correct values for the 2221 records. Is there a VB snippet that can do the following.
1. Open up the spreadsheet (PIML.HCEROUND.08152007.DUPFIX.xls)
2. Read the 2 columns of values in the tab labeled "PIML SWAP04"
3. Make the correlation between the values in the TagName column from the spreadsheet with that of the column called "TagName" in the SQL database.
4. Update the PiPointID and ServerName column where the TagName Values are equal.
Version of SQL: 2005
Any help is greatly appreciated