Check Date of Data in text File before Import? 1

[Clarkie001]

Hi,

I would be like to be able to check the date contained within a Text File before I import it into my database.

Any help on this would be much appreciated, thanks in advance.

Clarkie

 

[p27br]

you can get the creation date of your file with the File object DateCreated property.
set a reference to Microsoft Scripting Runtime

Dim fso As FileSystemObject
Dim fl As File
Set fso = New FileSystemObject
Set fl = fso.GetFile("c:\au.exe")
MsgBox fl.DateCreated