<div>
<p><br></p><p>&nbsp;It will only do the first tab. &nbsp; Range is a range of cells on that first tab or a named range in the spreadsheet.</p><p><br></p><p>&nbsp;If you have more than one sheet, you'd need to use VBA code and automation.</p><p><br></p><p>Jim.</p>
</div>





 It will only do the first tab.   Range is a range of cells on that first tab or a named range in the spreadsheet.




 If you have more than one sheet, you'd need to use VBA code and automation.




Jim.

<div>
Thanks -- I had that but just had the &quot;!&quot; in the wrong place and misspelled the sheetname variable.<br />
je
</div>


Thanks -- I had that but just had the "!" in the wrong place and misspelled the sheetname variable.
je

<div>
<div class="content wysiwyg-content">
I'm trying to import two different worksheets from an Excel file. &nbsp;When I set the 'range' = to the worksheet that I want, it still brings in the first worksheet.<br />
<br />
1st worksheet name = &quot;Functions&quot;<br />
3rd worksheet name = &quot;Role&quot;<br />
<br />
The frmTab variable is set to the worksheet name.<br />
<br />
Here is the code: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, frmTab, GetFile, True, frm_Tab<br />
<br />
???<br />
<br />
Thanks for your help,<br />
Jeanne
</div>
</div>


I'm trying to import two different worksheets from an Excel file.  When I set the 'range' = to the worksheet that I want, it still brings in the first worksheet.

1st worksheet name = "Functions"
3rd worksheet name = "Role"

The frmTab variable is set to the worksheet name.

Here is the code:                DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, frmTab, GetFile, True, frm_Tab

???

Thanks for your help,
Jeanne

Access - transferspreadsheet

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.