Import files into Access from Main directory

Hello everyone,

I am new to VBA but I do have an understanding of the code. Here is what I want to do:

The user clicks the main folder called XML. There are twenty folders in the XML tree (e.g. XML/Code/Programs/Data/Software/Files/etc.) and each folder contains a number of files consisting of txt, jpg, doc, xml, rtf, etc. The user wants all of the XML files from each folder in the tree to import into Access. I am looking for code that will allow the user to click the main XML folder and automatically search, find, and export all XML files from the rest of the folders in the tree to Access. Is there any code available that will do this or does anyone out there know how to do this?

Thanks,

bdthomas02

Comments

  • To Select a Folder --> API "SHBrowseForFolder" --> There are ton's of examples on the net.

    To search a Folder tree for files with a specific extension you need a recursive search-algorithm. The API's "FindFirstFile", "FindNextFile" and "FindClose" are your friends (i remember having coded something like this some years ago)

    : Hello everyone,
    :
    : I am new to VBA but I do have an understanding of the code. Here is
    : what I want to do:
    :
    : The user clicks the main folder called XML. There are twenty
    : folders in the XML tree (e.g.
    : XML/Code/Programs/Data/Software/Files/etc.) and each folder contains
    : a number of files consisting of txt, jpg, doc, xml, rtf, etc. The
    : user wants all of the XML files from each folder in the tree to
    : import into Access. I am looking for code that will allow the user
    : to click the main XML folder and automatically search, find, and
    : export all XML files from the rest of the folders in the tree to
    : Access. Is there any code available that will do this or does
    : anyone out there know how to do this?
    :
    : Thanks,
    :
    : bdthomas02
    :
    :

    ------------------------------------------
    Only stupidity of mankind and the universe
    are infinite, but i'm not sure concerning
    the universe. A. Einstein
  • Do you have the code to lean to me?
    : To Select a Folder --> API "SHBrowseForFolder" --> There are ton's
    : of examples on the net.
    :
    : To search a Folder tree for files with a specific extension you need
    : a recursive search-algorithm. The API's "FindFirstFile",
    : "FindNextFile" and "FindClose" are your friends (i remember having
    : coded something like this some years ago)
    :
    : : Hello everyone,
    : :
    : : I am new to VBA but I do have an understanding of the code. Here is
    : : what I want to do:
    : :
    : : The user clicks the main folder called XML. There are twenty
    : : folders in the XML tree (e.g.
    : : XML/Code/Programs/Data/Software/Files/etc.) and each folder contains
    : : a number of files consisting of txt, jpg, doc, xml, rtf, etc. The
    : : user wants all of the XML files from each folder in the tree to
    : : import into Access. I am looking for code that will allow the user
    : : to click the main XML folder and automatically search, find, and
    : : export all XML files from the rest of the folders in the tree to
    : : Access. Is there any code available that will do this or does
    : : anyone out there know how to do this?
    : :
    : : Thanks,
    : :
    : : bdthomas02
    : :
    : :
    :
    : ------------------------------------------
    : Only stupidity of mankind and the universe
    : are infinite, but i'm not sure concerning
    : the universe. A. Einstein

  • : Do you have the code to lean to me?

    Yeah, but i'm at work now, have to look it up at home. Tomorrow!
    ------------------------------------------
    Only stupidity of mankind and the universe
    are infinite, but i'm not sure concerning
    the universe. A. Einstein
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories