<div>
DoCmd.TransferSpreadsheet acImport, _<br />
&nbsp; &nbsp;10, strcTableName, _<br />
&nbsp; &nbsp;strFullPath, True<br />
<br />
This gives me the following error: External table is not in the expected format.<br />
<br />
&nbsp;DoCmd.TransferSpreadsheet acImport, _<br />
&nbsp; &nbsp;acSpreadsheetTypeExcel12xl<wbr />m, strcTableName, _<br />
&nbsp; &nbsp;strFullPath, True <br />
<br />
This gives me the following error: Could not find installable ISAM.
</div>


DoCmd.TransferSpreadsheet acImport, _
   10, strcTableName, _
   strFullPath, True

This gives me the following error: External table is not in the expected format.

 DoCmd.TransferSpreadsheet acImport, _
   acSpreadsheetTypeExcel12xlm, strcTableName, _
   strFullPath, True

This gives me the following error: Could not find installable ISAM.

<div>
upload a copy of the excel file..
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I am trying to import an xlsx file into access but seem to be having some difficulty.<br />
The code i am using is: <br />
&nbsp; ' Import into Access:<br />
&nbsp; DoCmd.TransferSpreadsheet acImport, _<br />
&nbsp; &nbsp;acSpreadsheetTypeExcel97, strcTableName, _<br />
&nbsp; &nbsp;strFullPath, True<br />
<br />
I think the error is with &quot;acSpreadsheetTypeExcel97&quot;<wbr /> but i am not sure.<br />
Any Ideas?<br />
<br />
Kind Regards,<br />
Andrew
</div>
</div>


Hi,
I am trying to import an xlsx file into access but seem to be having some difficulty.
The code i am using is: 
  ' Import into Access:
  DoCmd.TransferSpreadsheet acImport, _
   acSpreadsheetTypeExcel97, strcTableName, _
   strFullPath, True

I think the error is with "acSpreadsheetTypeExcel97" but i am not sure.
Any Ideas?

Kind Regards,
Andrew

Importing xlsx into Access 2007

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

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.