Results 1 to 3 of 3

Thread: Writing a filename to a database!!! Please Help!!!

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Ireland
    Posts
    224

    Question

    Hi guys,

    I have a load of file in a directory. How do I write all of the file names that are contained in that folder and all subfolders to a database table. Thanks for any help that anyone may be able to offer.

    Cheers
    JK

  2. #2
    Fanatic Member
    Join Date
    Oct 2000
    Location
    London
    Posts
    1,008
    You can retrieve filenames by using the Dir function which will return a string. To access the subdirectories, check the attributes of each dir entry for vbDirectory. Add these to an array and use the Dir function in a loop with recursion.

    Check out Dir in the VB help, its got some pretty good examples.

    P.
    Not nearly so tired now...

    Haven't been around much so be gentle...

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Ireland
    Posts
    224
    Thanks a lot for the help.
    Cheers
    JK

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width