Getting the filename of the latest file and import to table

[dhen21dx]

Hello

I need a help how can i get the filename of the latest file in a folder, cause i need to import it in the access table.

 

[welshgasman]

You could use FileDateTime() function
MS Access: FileDateTime Function

in conjunction with the DIR() function to look through all the files, and store the name of the highest date and time.?

How many files are we talking about.?

I would normally have had the file go into an import folder, then move/delete it after being imported?

You could try find latest file vba - Google Search

 

[dhen21dx]

You could use FileDateTime() function
MS Access: FileDateTime Function

in conjunction with the DIR() function to look through all the files, and store the name of the highest date and time.?

How many files are we talking about.?

I would normally have had the file go into an import folder, then move/delete it after being imported?

You could try find latest file vba - Google Search

FileDateTime function uses the filename, however, filename is dynamic as have dates or extra character within. Just check the second link and i think this is function VBA for excel.

 

[welshgasman]

There is more than one link there?
My thoughts were to check each file with the DIR and pass that filename returned to the FiledateTime function and if greater than the one stored, store that name?

The second link in the Google search actually mentioned VBA Access and asks exactly the same question???
Having looked at it, is is using the method I suggested?

 

[Micron]

I have to wonder if everyone is on the same page. What constitutes the "latest" file - it's create date? last modified date? A date that's part of the file name? I suspect the latter:

filename is dynamic as have dates or extra character within

@dhen21dx I think you need to clarify, and some examples of file names and you explaining which of those is the "latest" would help.

 

[dhen21dx]

I have to wonder if everyone is on the same page. What constitutes the "latest" file - it's create date? last modified date? A date that's part of the file name? I suspect the latter:

@dhen21dx I think you need to clarify, and some examples of file names and you explaining which of those is the "latest" would help.

The latest file refers to system modified date of the file, filename also includes date like filename20210708, filename20210709…

 

[Micron]

Then I'd say you have your answer in that you use that function in code to find the file with the latest modified date. The function is not an Excel function just because you read it on an Excel website. What you don't want to do is store the file itself in an Access db. Store the path instead and retrieve it from the folder when necessary.

 

[dhen21dx]

Got it now, thanks i will try to use the function then..