Results 1 to 4 of 4
  1. #1
    sanal is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Feb 2018
    Posts
    43

    Automate import from excel via vba

    The VBA to import data in 12 excel worksheets to 12 access tables of the same fields

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    save the file to a generic file: c:\temp\File2Import.xls
    Link the 12 sheets as external tables from the same file c:\temp\File2Import.xls
    build 12 append queries to import the 12 tables to the target table.
    put all queries into a macro.

    steps are then:
    1. overwrite the c:\temp\File2Import.xls with the new file,
    2. run macro

    done.

  3. #3
    sanal is offline Advanced Beginner
    Windows 10 Access 2007
    Join Date
    Feb 2018
    Posts
    43
    Thank you for reply.
    My question is how can the import from excel automate with vba code.

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664

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

Similar Threads

  1. automate import from file share
    By tagteam in forum Import/Export Data
    Replies: 2
    Last Post: 03-19-2014, 12:46 PM
  2. Automate Export/Import without linking?
    By djrickel in forum Import/Export Data
    Replies: 1
    Last Post: 03-13-2014, 02:52 PM
  3. Automate Import of Multiple .DBF Files.
    By Robeen in forum Access
    Replies: 8
    Last Post: 10-11-2013, 01:43 PM
  4. Automate Import of Excel data
    By tpcervelo in forum Import/Export Data
    Replies: 2
    Last Post: 07-29-2010, 12:19 AM
  5. Automate Excel Import to Access Related Tables
    By KramerJ in forum Programming
    Replies: 6
    Last Post: 04-04-2009, 04:24 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