Date Modified comes with Import

[bstice]

Hello all,

I have a DB that relies on three master tables. I import these master tables from CSV files that I save on a network on a monthly basis. My users would like to know when I have updated or imported this tables to my database.

During the import process is there a way with VB to capture the Date Modified data element of a CSV file and plug it into a separate table?

I would like to display the lastest updates on a master page so the user can determine how uptodate the data is. Thanks for the help in advance!

Brennan

 

[Alisa]

Found this in the access help:

DateLastModified Property


Description

Returns the date and time that the specified file or folder was last modified. Read-only.

Syntax

object.DateLastModified

The object is always a File or Folder object.

Remarks

The following code illustrates the use of the DateLastModified property with a file:

Sub ShowFileAccessInfo(filespec)
Dim fs, f, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(filespec)
s = UCase(filespec) & vbCrLf
s = s & "Created: " & f.DateCreated & vbCrLf
s = s & "Last Accessed: " & f.DateLastAccessed & vbCrLf
s = s & "Last Modified: " & f.DateLastModified
MsgBox s, 0, "File Access Info"
End Sub

 

[gemma-the-husky]

one other thing you could do, is rename the processed files when you save them to indicate a processed status

or you could save the processed file names in a table, with date processed, and any other relevant info