I need to import excel file into an existed table.
also i need to add importdate record into each row i import,
my code attached, have an issue, it`s update the importdate field for all new imported excel file and in all the table.
i need to edit it to be able to update only the new imported rows .
CurrentDb.Execute "UPDATE [" & strTable & "] SET ImportDate = #" & Format(Date, "mm/dd/yy") & "#", dbFailOnError