Results 1 to 3 of 3
  1. #1
    sathishkm is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Feb 2013

    Importing Excel Files

    Hi All,

    I have a list of excel files in one particular location. Now I have to import all these files in to access. Is there any query or vb code to import all these files.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    VBA code to loop through files in folder and possibly TransferSpreadsheet to import. This is fairly common topic in forum. Start with:

    Attempt code for your requirements and if you encounter specific issue, post question.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Anchorage, Alaska, USA
    And another site by Ken Snell with code examples:

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

Similar Threads

  1. Importing from several Excel files to Access.
    By cmdteardrops in forum Access
    Replies: 2
    Last Post: 10-02-2013, 03:33 PM
  2. regarding choking of access while importing excel files
    By ritimajain in forum Import/Export Data
    Replies: 1
    Last Post: 08-12-2013, 02:16 PM
  3. Replies: 10
    Last Post: 12-28-2012, 02:06 PM
  4. Replies: 7
    Last Post: 12-09-2012, 06:20 PM
  5. Replies: 6
    Last Post: 12-03-2012, 08:08 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