<div>
<div class="content wysiwyg-content">
I am using the following below to import from an Excel worksheet to Access 2003.<br />
<br />
I want it to always grab the first sheet in the workbook but the first sheet always has a different name. How can I specific this?<br />
<br />
DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel5, &quot;tmp_Import&quot;, FilePath, False, &quot;Sheet1!A3:F100&quot;
</div>
</div>


I am using the following below to import from an Excel worksheet to Access 2003.

I want it to always grab the first sheet in the workbook but the first sheet always has a different name. How can I specific this?

DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel5, "tmp_Import", FilePath, False, "Sheet1!A3:F100"

Import from Excel to Access

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.