Importing from a excel file from a spasific Worksheet

  • Thread starter Thread starter AJOLSON
  • Start date Start date
A

AJOLSON

I am useing the following command to import information from an excel file
DoCmd.TransferSpreadsheet acImport, , "InputTbl", "C:File\BAT.xls", False

My problem is that it will only import from the first excell worksheet in
this file. I want to import other data from othe worksheets within this
file.

How would I code to pull from a worksheet named "Template?" It is the third
worksheet from within this file.

Thanks
Andy
 
Back
Top