Hello,

I have this spreadsheet named sales with the following fields
AccountNumber
Last NAme
Date Visited
Status
.
.
.
. which is just a portion of a larger table in Access with the same nae Sales and more columns eg
AccountNumber
Last NAme
Date Visited
Status
.
.
.
Required is to update my Access table with the new information from the excel table which is mainly the fileds "Date Visited" and "Status" everything else remains the same. The primary column is AccountNumber.

Is there any way to have this automated ( codes that could updat the acess table with the new information that I have)

NB There is no limit to the number of rows to be updated. ie rows would be from 1 to lastrow

Thanks in advance