Unanswered: Update existing records from data in a spreadsheet
OK, I could use some help. I have a database which among other things tracks bandwidth usage by various systems. The IP address of these systems is static and I use that as the PK. My table which contains all of the system information (IPaddress, name, location, ect) periodiclly needs to get updated. For example I get updated location information from another department in the form of a spreadsheet with the IPaddress and the current location (some have changed, some havent. Also it may or may not contain information for all of the systems in the database). Is there a way to update the records with this information?