Hi,
I want to recall the date an Access db table was last modified into excel. I have tried the Excel gurus with no joy at all. So I am coming to the Access Gurus for the answer.

What is the syntax for the lastupdated date

I tried currentdb.tablename("table").lastupdated

but got errors

for info
db = "t:1 depts\planning\planning.mdb"
table = "forecast"

Thanks in advance for your wisdom

If you are trying to determine the last time data was changed in a table, you need to add your own timestamp column to the table and then update the date/time in each form's BeforeUpdate event. You would then run a query to get the Max() LastUpdateDt.