Results 1 to 2 of 2
  1. #1
    jurbin is offline Novice
    Windows Vista Access 2007
    Join Date
    Jan 2014
    Posts
    15

    Import multiple Excel Files into 1 access table

    Hello, I have seen multiple people ask this question and get some responses, but I cannot always fully understand some of the code. I am very new to code and vba, I usually just use access without it.

    I need to import multiple excel files all at once which are all located in one folder. I essentially need to import every file from the folder into the same access table. Same headings on each file, etc. I also only want to import the first tab on each excel sheet.



    I cannot figure out some of the vba people send back. I am not sure where I need to add my table name, folder location of excel files etc.

    Can anyone help with a somewhat 'VBA Code for Dummies' response?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Every situation is unique. Must adapt code. Since we don't know your details, you will have to write some code and post with description of issues encountered for analysis.

    Search forum on topic 'import multiple excel files'. I get 37 threads.

    Also review: http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 06-16-2014, 08:37 AM
  2. Import Multiple Excel Files with SAME layout to Access
    By torontoraptor in forum Programming
    Replies: 2
    Last Post: 05-12-2014, 10:29 AM
  3. Replies: 1
    Last Post: 03-25-2014, 08:54 PM
  4. Replies: 19
    Last Post: 10-08-2012, 07:47 AM
  5. Replies: 1
    Last Post: 06-27-2012, 07:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums