Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2010
    Posts
    4

    Importing the second excel worksheet


    Hi,
    I'm trying to import the second worksheet in an excel file to access. I am wondering if this is possible.
    Last edited by geoffwbailey; 06-25-2010 at 05:55 AM.

  2. #2
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "Sheet1", "C:\test.xls", True, "Sheet1$"

    The Highlighted part is the reference to the sheet. Rember to put the $ Sign after the name of the sheet.


    if this solves your problem mark the thread solved.

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

Similar Threads

  1. Importing Excel into Access
    By Nel1975 in forum Access
    Replies: 3
    Last Post: 12-30-2009, 10:21 AM
  2. Importing Data From Excel
    By king_bowzow in forum Import/Export Data
    Replies: 1
    Last Post: 09-11-2009, 02:26 AM
  3. iMPORTING DATA FROM EXCEL TO ACCESS
    By Rameez in forum Import/Export Data
    Replies: 7
    Last Post: 06-16-2009, 12:05 PM
  4. importing excel spreadsheet issues
    By majortool in forum Import/Export Data
    Replies: 1
    Last Post: 01-24-2008, 06:29 PM
  5. Importing from Excel
    By joer in forum Forms
    Replies: 0
    Last Post: 03-14-2007, 02:01 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