Import files name to table - name,extension,creation date

[Magnus1982]

Hello,


I am lookinh way to import filename from directory in to access tabel. But I want to have imported to 3 sapereate column in tabel file name , extension, creation date.


I found many codes which doing that but all copying file name to one column .


Please help.


Thank you

 

[jdraw]

You might want to review the Dir command and its options. You could create a file and link to it from Access.

Good luck

 

[Pat Hartman]

To parse the file names, you will need to use the Left(), Mid(), and Right() functions.

 

[Galaxiom]

Another way is to use FileSystemObject, which has methods to return what you want without having to parse strings.

 

[Pat Hartman]

I didn't see any FSO property that separates the file name from the extension. Perhaps you could point it out.

 

[MarkK]

Here are some FSO functions that process filenames. The first two, GetBaseName and GetExtensionName will both separate the filename from the extension.

Sub Test928346912487()
    Const TMP = "C:\Folder\File.txt"
    
    With CreateObject("Scripting.FileSystemObject")
        Debug.Print .GetBaseName(TMP)
        Debug.Print .GetExtensionName(TMP)
        Debug.Print .GetFileName(TMP)
        Debug.Print .GetDriveName(TMP)
        Debug.Print .GetParentFolderName(TMP)
    End With
End Sub

Mark