<div>
Hi <br />
&nbsp; Please see this link maybe help<br />
&nbsp; <a href="http://www.utteraccess.com/forum/DoCmdTransferSpreadsheet-t1942701.html" rel="ugc">http://www.utteraccess.com/forum/DoCmdTransferSpreadsheet-t1942701.html</a>
</div>


<div>
<div class="content wysiwyg-content">
The following code is under a command button on an Access form:<br />
. &nbsp; <br />
DoCmd.TransferSpreadsheet acExport, acspreadsheetTypeExcel19, &quot;tblMaster&quot;, &quot;C:\Users\Danny\Desktop\tb<wbr />lData.xls&quot;<wbr /><br />
<br />
&nbsp;I have an empty Excel file named &quot;tblData&quot; that is saved on my desktop. <br />
<br />
The error message I'm getting is: Run time error 3170. &nbsp; Could not find installable ISAM.<br />
<br />
I created the database on a different machine with Access 2003 installed. &nbsp;I'm currently trying to run the code on this machine, which has Access 2010 installed. &nbsp; <br />
<br />
What's the problem? &nbsp;Thanks.
</div>
</div>


The following code is under a command button on an Access form:
.   
DoCmd.TransferSpreadsheet acExport, acspreadsheetTypeExcel19, "tblMaster", "C:\Users\Danny\Desktop\tblData.xls"

 I have an empty Excel file named "tblData" that is saved on my desktop. 

The error message I'm getting is: Run time error 3170.   Could not find installable ISAM.

I created the database on a different machine with Access 2003 installed.  I'm currently trying to run the code on this machine, which has Access 2010 installed.   

What's the problem?  Thanks.

Hi 
  Please see this link maybe help
  http://www.utteraccess.com/forum/DoCmdTransferSpreadsheet-t1942701.html

Proble transferring an Access table into Excel

The following code is under a command button on an Access form:
.   
DoCmd.TransferSpreadsheet acExport, acspreadsheetTypeExcel19, &quot;tblMaster&quot;, &quot;C:\Users\Danny\Desktop\tblData.xls&quot;

 I have an empty Excel file named &quot;tblData&quot; that is saved on my desktop. 

The error message I&#39;m getting is: Run time error 3170.   Could not find installable ISAM.

I created the database on a different machine with Access 2003 installed.  I&#39;m currently trying to run the code on this machine, which has Access 2010 installed.   

What&#39;s the problem?  Thanks.

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.

Microsoft Access

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