Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2005
    Posts
    15

    Unanswered: How can I automate the import of a folder full of .csv files?

    I need to routinely import a folder of .csv's into a single table in Access. The file names are never the same and the folder name changes as well. They (obviously) all use the same import specification, however.

    Can anyone help me write this function?

    Thanks a lot!

  2. #2
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    This should get you thinking in the right direction:
    http://support.microsoft.com/?kbid=198467
    Obviously, some changes will be needed; hope you can do 'em.

  3. #3
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    I'd suggest you look in your access help.
    Go to Contents
    Under Objects, look at File Object, Files Collection, FileSystemObject, Folder Object, and Folders Collection.

    I think you'll have a problem without knowing the folder name at run time, though.
    Inspiration Through Fermentation

  4. #4
    Join Date
    Jan 2005
    Posts
    15

    Thanks!

    Thank you so much! I've coded it in and it works perfectly. The processing time is not bad either!

  5. #5
    Join Date
    Jan 2005
    Posts
    15
    I had to throw an input field in the form for the user to input the subfolder. The import works perfectly and now I'm just cleaning up import error tables. Thank you for all your help!

Posting Permissions

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