Results 1 to 2 of 2
  1. #1
    mkc80 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2012
    Posts
    56

    Best Way to Import Excel Data from multiple sheets in to multiple tables in Access

    I would like to know which way is the best way to import excel data from multiple sheets in to multiple tables in access.


    For example data from Sheet1 -> Table1, Sheet2->Table2, Sheet3->Table3 etc...

    I have tried using this:
    Cmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel5, "Table1", "C:\Importedfile.xlsx", True, "Sheet1!"

    Ironically, data from Sheet2 and Sheet3 seem to be properly imported in to table2 and table3, but some of the data from Sheet1 seems to be missing in Table1 after import.

    Any other ways/suggestions to import the data?

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,465
    Check out Ken Snell's Excel page at:
    http://www.accessmvp.com/kdsnell/EXCEL_MainPage.htm

    There is lots of code to import/export spreadsheets
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

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

Similar Threads

  1. Import Excel Data to Multiple Access Tables
    By colby in forum Import/Export Data
    Replies: 3
    Last Post: 11-04-2011, 12:17 PM
  2. Combine multiple Excel sheets in Access
    By Adcock1969 in forum Access
    Replies: 17
    Last Post: 09-07-2011, 06:03 AM
  3. Replies: 4
    Last Post: 06-14-2011, 07:19 PM
  4. Splitting an Excel File into Multiple Access Tables on Import
    By TheWolfster in forum Import/Export Data
    Replies: 4
    Last Post: 04-29-2010, 04:52 AM
  5. Replies: 0
    Last Post: 04-29-2009, 04:27 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