Import File List into database

  • Thread starter Thread starter Alan Z. Scharf
  • Start date Start date
A

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
 
3. I've tried Scripting.FileSystemObject, but no luck so far. Is there
another way to access the filenames?
Click to expand...

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
 
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
|
|
|
 
Back
Top