Forum Discussion
how to get current date, then have it NOT change
I receive excel files once a month (exports from other systems). To help me keep better track of these items from month to month, I want to import them into Access. I know I can run a query that wou...
I understand that maybe the way I asked was unclear. Sometimes I don't express correctly what's in my head.
Is there a way for Access to get the date that the excel data is imported/added? So that the date will never change. I'm trying to build it so when I run import, then the date that the data is imported, will be added without me going into the query and adding a static date.
I hope this is clearer...
You'll have to create a field to store that date, something like "DateImported" in the table where the data is stored. Then it will be saved as part of the import process if you use Date() in the import query to populate it. Similar to what Arnel suggested.