list files in a folder

[ni2shiv]

hi,

How to list files in a folder & subfolder in a main folder store that file names in MS-Access database. Please reply me.

For example

H:\Folder1\SS\

The SS folder contains other folders like LV-11, LV-1, LV-10

I like to store it in database as

DT-11 LV-11
file1 file1
file2 file2
file3 file3
file4 file4
file5 file5
file6 file6

Please reply me.

[msanchez]

To access files and folders as objects and collections you can iterate through, utilize the File System Object (FSO).

You can enter these file names into your Access database via the ADO connection object, amongst others.

Resources:
FSO

ADO

Database Connection Strings

Good luck,

[ni2shiv]

Hi Michael Sanchez,

Thanks for your reply, for this links are of great help...thanks a ton...

Ni2shiv