hpfam
asked on
Is this possible
Is it possible to retrieve a list of directories and the their subfolders from within access to import into a table. If this is how would it go about being done. I would like to get size of the file as well. The code would be great.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
dentab I would prefer to store in a table but if it is eaiser to export to a txt file or excel I can live with it.
Yes sorry, what I meant was the structure of the table.
By example is of two methods of storing the same information.
Also are we talking access here? or Oracle or SQL Server...?
By example is of two methods of storing the same information.
Also are we talking access here? or Oracle or SQL Server...?
i.e. Record =
ID
Parent Folder
Name
IsFolder
e.g.
1
\
Windows
True
2
ReadMe.txt
False
or
Path
isFolder
C:\Windows\
True
C:\Windows\ReadMe.TXT
False