Need help with importing excel files

[freightguy]

Hello Helpful Members,
I'm fairly new to access, and already need some help. I'm trying to establish a business process where a provider sends a daily excel report to me that I upload into access. The trick is that I want the daily upload to replace only fields in the table that have new entries. Is this possible?

[Luigi]

Hello Helpful Members,
I'm fairly new to access, and already need some help. I'm trying to establish a business process where a provider sends a daily excel report to me that I upload into access. The trick is that I want the daily upload to replace only fields in the table that have new entries. Is this possible?

I thing you must have an internal table with the Current situation and than another table CONNECT to an excel file (make a working copy of the incoming file with a fixed name). So you can make a COMMAND QUERY that finds the different and up-date the Current table.