how to choose the tab in an excel spreadsheet to import to access

  • Thread starter Thread starter sainati
  • Start date Start date
how to choose the tab in an excel spreadsheet to import to access

using the Excel Object Model, grab the worksheets collection of the
workbook object and write them somewhere... a dropdown menu? a
listbox?
 
I know you can do it from the wizard easily, but I can't find any where how
to do it using the transferspreadsheet method programaticlly.
 
You don't need to use Automation to do what you want.
To specify a specific worksheet in an Excel file, use the name of the sheet
in the Range argument of the TransferSpreadsheet.

If you want to do it programmatically, you can use VBA or a Macro.
Open the VBA editor, click on help, type in TransferSpreadsheet. For a
maco, choose the Action. For VBA choose the Method.
 
Back
Top