Conditional Update of Values from Excel Sheet

[PicoTTS]

Hi,



I am wondering if there is a way to update/overwrite some of the value in my table with the values in an excel sheet. The values in my table should only be overwritten if certain conditions are met.

Example

I have a table with shipment tracking numbers and shipping dates along with a bunch of other misc data about that shipment. I also have an excel with some new updated information that only has the tracking numbers and dates.

Is there a way to easily update the dates on my access table with the new dates in the excel file if certain conditions for that specific tracking number are met?

I am trying to automate this process so I would like to have a macro or something that I could run that compares the data and updates the values if needed.

Thanks

[Micron]

if you link the spreadsheet as a table and run an update query against your db table using the linked one as the source, then if there's updated data, it will overwrite. If there isn't, it won't make any difference. Unless you run an update when you shouldn't (for whatever reason that might be) then you can run it as many times as you want. No difference in source = no difference in target. You just have to decide how you want the query to be executed.

[PicoTTS]

I am not that familiar with update queries. Would I be running the update query in VBA in excel?

[Micron]

if you link the spreadsheet as a table and run an update query against your db table using the linked one as the source

I had "lined" which I've corrected to "linked". If that doesn't clear it up, then
- you link to the spreadsheet from Access
- you have a db table already according to what I've gleaned from your first post
- you update that table based on what's in your linked table (spreadsheet)
- you use an update query to perform that update
- unless you have some sort of special need, you don't need run to this query as code, although you might run/call it from button click code. That's not the same thing.
- you google/bing "ms access update query" if you don't know what that is