Importing from a excel file from a spasific Worksheet

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem Importing Specific Worksheet From Workbook 6
Import from a specific Worksheet 2
importing a worksheet info to an existing access table 2
Import Excel Data from Ranges on a Worksheet 3
Importing Multiple Excel Worksheets into An Access Table 4
Excel File won't Import into Access 1
Excel file won't import unless open 1
Import form Excel 3

Top