Help on creating a special table

[smoon]

I need help on how to create a table that is populated with file names read from various directories on the hard drive. I am pretty new to Access and would appreciate any help.

Thanks

[furious1]

As far as the directories are concerned, you could write a series of update queries as an event, if you point to the path on your hard drive. If you could give me more of an idea as to what you're trying to do, I might be able to help you.

[PinkPanther2003]

How are you going to access the file system using JET???? SQL doesn't know it exists.

Why do you want to store information you can get dynamically using VBA?

The only way I can see to do it is to use VBA.


Code stolen from 7.0 help file:

' Display the names in C:\ that represent directories.
MyPath = "c:\" ' Set the path.
MyName = Dir(MyPath, vbDirectory) ' Retrieve the first entry.
Do While MyName <> "" ' Start the loop.
' Ignore the current directory and the encompassing directory.
If MyName <> "." And MyName <> ".." Then
' Use bitwise comparison to make sure MyName is a directory.
If (GetAttr(MyPath & MyName) And vbDirectory) = vbDirectory Then
Debug.Print MyName ' Display entry only if it

End If ' it represents a directory.
End If
MyName = Dir ' Get next entry.
Loop

HTH,

Peter