Importing Excel multi tabs into Access

I have a form with a button on it that will allow a user to import an Excel
spreadsheet into a table in my database. I am using transferspreadsheet.
It works fine if the data in the Excel worksheet is in the first tab or
sheet. Is there any way to have the user select the tab for the import? Or
preset it so that it always looks for a specific tab?
Thanks!

Check the examples at http://www.accessmvp.com/KDSnell/EXCEL_Import.htm

You just need to specify the name of the worksheet in the Range argument of
TransferSpreadsheet.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/



"Glen" <Glen@discussions.microsoft.com> wrote in message
news:8EEDFC1A-6312-491E-AD7D-ECDDC5F4797F@microsoft.com...
>I have a form with a button on it that will allow a user to import an Excel
> spreadsheet into a table in my database. I am using transferspreadsheet.
> It works fine if the data in the Excel worksheet is in the first tab or
> sheet. Is there any way to have the user select the tab for the import?
> Or
> preset it so that it always looks for a specific tab?
> Thanks!

Thanks!

"Ken Snell MVP" wrote:

> Check the examples at http://www.accessmvp.com/KDSnell/EXCEL_Import.htm
>
> You just need to specify the name of the worksheet in the Range argument of
> TransferSpreadsheet.
> --
>
> Ken Snell
> <MS ACCESS MVP>
> http://www.accessmvp.com/KDSnell/
>
>
>
> "Glen" <Glen@discussions.microsoft.com> wrote in message
> news:8EEDFC1A-6312-491E-AD7D-ECDDC5F4797F@microsoft.com...
> >I have a form with a button on it that will allow a user to import an Excel
> > spreadsheet into a table in my database. I am using transferspreadsheet.
> > It works fine if the data in the Excel worksheet is in the first tab or
> > sheet. Is there any way to have the user select the tab for the import?
> > Or
> > preset it so that it always looks for a specific tab?
> > Thanks!
>
>
>