Importing Excel Spreadsheet with updates RRS feed

  • Question

  • I have a database where I import data from an excel spreadsheet into a table. When importing the information there is a chance that some of the current data may have change. For example, an entry for an existing claim may have changed form an "Open" status to a "Closed" Status. When I import the data it will not overwrite to update any of the changes. Can you tell me how I can make this happen?
    Monday, April 3, 2017 8:56 PM

All replies

  • You can import to a temp table and then run an UPDATE query on the fields you know to be apt to change.

    Then use another query to find and records that do not match to see if you wish to revise/update other fields.

    Build a little, test a little

    • Proposed as answer by Chenchen Li Tuesday, April 4, 2017 6:17 AM
    Tuesday, April 4, 2017 2:24 AM