Importing Excel multi tabs into Access

  • Thread starter Thread starter Glen
  • Start date Start date
G

Glen

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!
 
Back
Top