Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2012

    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?

  2. #2
    Join Date
    Apr 2004
    metro Detroit
    Yes there is. You can either link the xls file or import it to a table then use it in an update query.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts