Importing a Excel Spreadsheet

[wan2fly99]

I tried to import a spread sheet with some code.

Here it is

Private Sub Command0_Click()
On Error GoTo Err_Command0_Click


DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "ImportTable", "c:/Tony.xls"


Exit_Command0_Click:
Exit Sub

Do you know what I have to type in for the Excel Spreead sheet to pick up a specific sheet?

Spreadsheet is called: Tony.xls. It has 3 different sheets inside. I would just like to import a specific one

 

[Taff]

Hi wan2fly99,

Try

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "ImportTable", "c:/Tony.xls", , YourSheetName

Taff.