Import spreadsheet with modified date

[Jim]

I'd like to import a spreadsheet to append to an existing table that has a
field for the modified date of the spreadsheet. Is there code that can
automate importing the spreadsheet and populate this field? We will be
getting updates periodically, and I'd like to be able to capture that
information in the table so I can easily see which update the data came in on.

Thanks,
Jim

 

[Douglas J. Steele]

You can run an Update query that puts a given date into the ModifiedDate
field for any rows where it's blank:

UPDATE MyTable
SET ModifiedDate = Now()
WHERE ModifiedDate IS NULL