reading dirs, sub-dirs and file names (Long Question)

[Doug Kassay]

I will start out with what I would like to ultimately accomplish and
then follow it up with some questions.

I want to build an app using VB or Access that will build related tables
from my directory structure and files. the User will create the initial
root directory. Lets call it music. under music will be many
sub-directories called artist1, artist2, etc. under each of these will
be disc1, disc2, etc.. and/or individual files xx1.xyz, xx2.xyz, etc..,
under each disc1 sub-dir there will only be files xx1.xyz, xx2.xyz,
etc.. I would like to scan the root directory and build my tables so
that each file is linked to its either the disc directory or the artist
directory and each disc directory is linked to the artist directory.

Is this possible?

What is better to use, VB or Access?

What is the best book on Visual Basic that is well indexed and gives
language examples?

What would an example of the required code look like?

I have been currently doing this with the the dos command dir /s >
list.txt and then using an Excel macro to import the *.txt file and
manipulate into the proper structure and then coping into the Access
DB. This is very labor intensive and needs to be done everytime I add a
file and/or directory to my Root Dir. Any pointers in the right
direction would be appreciated. Please also reply to my email address.