<div>
perfect - thank you, I used true rather than false at the end as the spread sheet had headers &amp;&nbsp;that did the trick
</div>


perfect - thank you, I used true rather than false at the end as the spread sheet had headers & that did the trick

<div>
<div class="content wysiwyg-content">
Dear Experts <br />
<br />
This is a really weird one ... &nbsp;I am trying to import an excel spreadsheet into Access using the following code:<br />
<br />

<pre><code id="code-10-28282123-1">DoCmd.TransferSpreadsheet acImport, , &quot;SMS Import&quot;, &quot;C:\Users\xxxx\Desktop\SMS Import.xlsx&quot;</code></pre>
<br />
I keep getting an error saying &quot;Field F1 doesn't exist in destination table 'SMS Import'&quot; - so to make sure I wasn't missing anything I exported the data that already existed in the table to excel and then tried to reimport it - I still got the same error!<br />
<br />
Any ideas - I have tried adding a reference to Microsoft Excel 14.0 Object library as well as Microsoft Office 14.0 Object library - no difference though
</div>
</div>


Dear Experts 

This is a really weird one ...  I am trying to import an excel spreadsheet into Access using the following code:

(CODE)

I keep getting an error saying "Field F1 doesn't exist in destination table 'SMS Import'" - so to make sure I wasn't missing anything I exported the data that already existed in the table to excel and then tried to reimport it - I still got the same error!

Any ideas - I have tried adding a reference to Microsoft Excel 14.0 Object library as well as Microsoft Office 14.0 Object library - no difference though

Excel Import to Access

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.