<div>
<br />
Thanks Pete, that problem is solved. I just left the argument blank. Also the spread sheet I was trying to import was in tab-delimited format. I had to change it into Excel spread sheet format. Do you have any solution for that?<br />
<br />
Thanks,<br />
st
</div>



Thanks Pete, that problem is solved. I just left the argument blank. Also the spread sheet I was trying to import was in tab-delimited format. I had to change it into Excel spread sheet format. Do you have any solution for that?

Thanks,
st

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I am trying to use the following to import an excel datasheet into MS access table. <br />
<br />
DoCmd.TransferSpreadsheet acImport, 3, _<br />
&nbsp; &nbsp; &quot;Report&quot;, &quot;C:\Rep\Report.xls&quot;, True, &quot;A1:L3000&quot;<br />
<br />
and I am getting <br />
Runtime error 3274<br />
External table is not in the expected format.<br />
<br />
Please help.<br />
<br />
Thanks,<br />
st 
</div>
</div>


Hi

I am trying to use the following to import an excel datasheet into MS access table. 

DoCmd.TransferSpreadsheet acImport, 3, _
    "Report", "C:\Rep\Report.xls", True, "A1:L3000"

and I am getting 
Runtime error 3274
External table is not in the expected format.

Please help.

Thanks,
st 

runtime error 3274

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.