Directory listing to table with file attributes size and date

[mulligh]

Hello all

I want to get a listing of files in a particular directory and turn that into a table in MS Access. I also want to get the lastmodified date of the file and also the filesize. Since the contents of the directory change, I'll need to refresh the table either automatically when the database opens or on demand. It looks like I'll need to use the Windows Script Host Object model reference to get those attributes but I'm not sure how to put this all together. Can someone help me? Thanks.

 

[PHV]

Do a google search for FileSystemObject

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mulligh]

Thanks. I know about FSO, but I was just wondering whether anyone has seen a script that does this. I've found scripts that work in Excel but not Access.

 

[mulligh]

Nevermind. I'm withdrawing the question.