A
Amanda Payton
I have a series of 4 CSV files that I want to import into access any time
their last modified date is newer than the date of the last import(recorded
in a table). (these files will be periodically replaced by a new file of the
same name - so the created / modified dates will change roughly once a
month.) Right now I have the files linked, and use an append query to
transfer the data from the linked tables to one master table. I'm doing it
this way rather than importing with transfertext because there is some
manipulation of data (trimming extraneous characters) and filtering that has
to happen before the data will meet validation rules.
The problem that I have is this: If I right-click on one of the linked CSV
files and look at properties - I see one date (in this case - yesterday) but
if I use the FileDateTime function - I get something different - usually very
close to the current date / time. (this code runs at program startup).
Is a file considered "modified" if a program accesses it? Is FileDateTime
picking up on the fact that the files are linked - and treating that as a
modification?
I CAN set up the files on an import basis instead of a linked basis - but
I'd rather not go to the effort if I can help it.
-Amanda
their last modified date is newer than the date of the last import(recorded
in a table). (these files will be periodically replaced by a new file of the
same name - so the created / modified dates will change roughly once a
month.) Right now I have the files linked, and use an append query to
transfer the data from the linked tables to one master table. I'm doing it
this way rather than importing with transfertext because there is some
manipulation of data (trimming extraneous characters) and filtering that has
to happen before the data will meet validation rules.
The problem that I have is this: If I right-click on one of the linked CSV
files and look at properties - I see one date (in this case - yesterday) but
if I use the FileDateTime function - I get something different - usually very
close to the current date / time. (this code runs at program startup).
Is a file considered "modified" if a program accesses it? Is FileDateTime
picking up on the fact that the files are linked - and treating that as a
modification?
I CAN set up the files on an import basis instead of a linked basis - but
I'd rather not go to the effort if I can help it.
-Amanda