Import File List into database

[Alan Z. Scharf]

1. I want to import the filnames and datemodified from a folder into Access,
one record for each filename.

2. How can I do this.

3. I've tried Scripting.FileSystemObject, but no luck so far. Is there
another way to access the filenames?

Thanks.

Alan
___________________________
Alan Z. Scharf
GrapeVine Systems
New York City

 

[Tim Ferguson]

3. I've tried Scripting.FileSystemObject, but no luck so far. Is there
another way to access the filenames?

Set fdr = fso.GetFolder("S:\ome\path")

For each fil in fdr.Files
debug.print fil.Name,,,
debug.print fil.DateLastModified

Next fil

What difficulty were you having?


Tim F

 

[Alick [MSFT]]

Hi Alan,

You may want to refer to the following web to get start with
FileSystemObject.

FileSystemObject Basics
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/ht
ml/jsFSOTutor.asp

Programming the FileSystemObject
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/ht
ml/sgProgrammingFileSystemObject.asp

DateLastModified Property
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/ht
ml/jsprodatelastmodified.asp

Please feel free to reply to the threads if you have any questions.



Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.


--------------------
| Reply-To: "Alan Z. Scharf" <[email protected]>
| X-Tomcat-NG: microsoft.public.access.modulesdaovba
|
| 1. I want to import the filnames and datemodified from a folder into
Access,
| one record for each filename.
|
| 2. How can I do this.
|
| 3. I've tried Scripting.FileSystemObject, but no luck so far. Is there
| another way to access the filenames?
|
| Thanks.
|
| Alan
| ___________________________
| Alan Z. Scharf
| GrapeVine Systems
| New York City
|
|
|