Results 1 to 2 of 2
  1. #1
    jstei012 is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    2

    import excel files into access automatically

    I’m very new to using VBA in Access, so if anyone can help me I would greatly appreciate it.

    This is what I need help with:



    I have to create a system that automatically imports Excel files from a folder in the hard drive into an Access table. I want to make it so all the users have to do is hit a button and everything happens automatically. I know it’s possible because I was able to create it using VBA in Excel but I can’t make it work for Access.

    I believe I have to use "currentproject.path" instead of "ThisWorkbook.Path" but I’m not entirely sure. All the files are save in this format: “Seating Chart Report- city name.xls” The city name is different for every file. The subfolder all the files are saved in is called “Attachments” and the table they need to be imported into is called “Seating Chart.” The Excel files and Access database are both located in the same main folder called "Seating Chart Project."



  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    Do Google searches for "File Picker Access VBA" (store file location in a textbox) and "Access VBA transferspreadsheet" (import file from specified location)

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

Similar Threads

  1. Replies: 9
    Last Post: 10-31-2013, 06:51 AM
  2. Import multiple text files automatically
    By instructorTek in forum Import/Export Data
    Replies: 30
    Last Post: 10-20-2012, 04:50 PM
  3. Import Excel files on SharePoint 2010
    By jgelpi16 in forum Import/Export Data
    Replies: 1
    Last Post: 10-31-2011, 01:32 PM
  4. Replies: 3
    Last Post: 10-06-2011, 06:53 AM
  5. Cannot import excel or text files
    By donald_s in forum Access
    Replies: 2
    Last Post: 04-13-2010, 11:48 PM

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