Import files name to table - name,extension,creation date (1 Viewer)

Magnus1982 · Jul 18, 2018

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 · Jul 18, 2018

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 · Jul 19, 2018

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

Galaxiom · Jul 19, 2018

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

Pat Hartman · Jul 19, 2018

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

MarkK · Jul 19, 2018

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

Code:

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

Import files name to table - name,extension,creation date (1 Viewer)

Magnus1982

Registered User.

jdraw

Super Moderator

Pat Hartman

Super Moderator

Galaxiom

Super Moderator

Pat Hartman

Super Moderator

MarkK

bit cruncher

Similar threads

Users who are viewing this thread