Hi,
I'm trying to import the second worksheet in an excel file to access. I am wondering if this is possible.
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.
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.