<div>
Is this code being executed from within a Form? &nbsp;If you do Debug&gt;&gt;Compile ... are there any errors?<br />
<br />
mx
</div>


Is this code being executed from within a Form?  If you do Debug>>Compile ... are there any errors?

mx

<div>
peter57r: me.txtfilename stores the path and file when the end user selects the file<br />
<br />
DatabaseMX: I do not get any errors when compiling
</div>


peter57r: me.txtfilename stores the path and file when the end user selects the file

DatabaseMX: I do not get any errors when compiling

<div>
Actually, peter57r I mispelled the field name in the code.<br />
<br />
That was it, it should be me.textfilename<br />
<br />
Thanks!
</div>


Actually, peter57r I mispelled the field name in the code.

That was it, it should be me.textfilename

Thanks!

<div>
<div class="content wysiwyg-content">
Hi all I get this error in my Access 2003 form. When I click the debug button it highlights the code listed below<br />
<br />
The table does exist and my Excel version is 2003.<br />
Any ideas?<br />

<pre><code id="code-8206987">DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, &quot;tmpTableA&quot;, Me.txtFileName, True, &quot;A:A&quot;</code></pre>
</div>
</div>


Hi all I get this error in my Access 2003 form. When I click the debug button it highlights the code listed below

The table does exist and my Excel version is 2003.
Any ideas?

Run-time error 3270: Property not found in Access 2003 form

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.