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

P

pietlinden

how to choose the tab in an excel spreadsheet to import to access
Click to expand...

using the Excel Object Model, grab the worksheets collection of the
workbook object and write them somewhere... a dropdown menu? a
listbox?
 
S

sainati

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.
 
K

Klatuu

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.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Access - importing an excel spreadsheet 0
Importing Excel Spreadsheet into Access 6
Importing Excel spreadsheet 21
Importing Specific Tabs using macro 2
Import Excel 2010 table into Access 2010 - not listed as range 1
Import Excel File into EXISTING Access Table 2
Excel Excel spreadsheets opening at top instead of bottom. 4

Top