Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007
    Posts
    35

    Unanswered: automate import of many identical spreadsheets

    Hi again.

    I have several folders each containing the same identical set of excel files, where every folder stands for a specific lab.
    I have another folder that contains one excel file that should import data from the above folders and place it sequentially one below another.
    I can basically import one spreadsheet at a time from the menu's Import Data tool, but that will take me a decade, and I'm not so sure what would happen if I decided to change the folder structure.
    So, is there a way to automate the procedure?

    Thanks,
    Ron

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,468
    Provided Answers: 10
    Do what i do records you steps
    play it a couple of times the view the code (change it see what happen)
    with in a month or 2 you be written the code
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

Posting Permissions

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