Link to home
Start Free TrialLog in
Avatar of hpfam
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
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
yes easily... but it depends how you want to store them...

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

 
Avatar of hpfam
hpfam

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...?