Re: File Modification Date
- From: "Jeff Boyce" <nonsense@xxxxxxxxxxxx>
- Date: Thu, 6 Sep 2007 10:43:31 -0700
Kirk
You might need to do a bit of on-line searching, and searching in Access
HELP. I seem to recall that there IS a way to get attributes of files
(e.g., creationdate), but I don't recall HOW...
Perhaps one of the other newsgroup readers recalls the 'how'...
Good luck!
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Kirk P." <KirkP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:549F885C-7615-4446-B114-4F3D28245A09@xxxxxxxxxxxxxxxx
I'm looking to capture the date the text file was created.
"Jeff Boyce" wrote:
Kirk
I'm not clear on what you want. The date the text file was created
(before
importing)? The date the text file was imported?
Since text files are rarely well-normalized, and since Access has
relationally-oriented features and functions, you (and Access) are
probably
better off taking the raw import data and 'parsing' it into more
permanent
(and better-normalized) tables ... so do you want the date you 'parsed'
the
input?!
Regards
Jeff Boyce
Microsoft Office/Access MVP
"Kirk P." <KirkP@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:074A22C8-75F7-4A97-9143-EE8455C527BE@xxxxxxxxxxxxxxxx
I'm importing a bunch of text files. I would like to capture the date
the
text file was actually created (modification date) in the import. Can
I
do
that?
.
- Follow-Ups:
- Re: File Modification Date
- From: John Nurick
- Re: File Modification Date
- References:
- Re: File Modification Date
- From: Jeff Boyce
- Re: File Modification Date
- Prev by Date: Re: Problem linking to SQL tables in Access
- Next by Date: Re: Exporting Excel to Access - formating text box to memo
- Previous by thread: Re: File Modification Date
- Next by thread: Re: File Modification Date
- Index(es):
Relevant Pages
|