System Architect

Bob Collison

<div>
Hi John,<br />
<br />
I copied your code in verbatum and it still doesn't load anything.<br />
<br />
Thanks,<br />
Bob C.
</div>


<div>
Bob i did gave it &nbsp;a quick test and it was working<br />
Maybe there is more than one mistake....check the path of the excel..<br />
Take note that i took for granted that RS07ImportDataAddGrp0003 is the name of the table not a variable holding the table's name...if not you don't need the double quotes and probably you have some other kind of issue...e.g. corruption (?)
</div>


<div>
Hi John,<br />
<br />
RS07ImportDataAddGrp0003 is a variable containing the Table Name of 07_IMPORT_DATA.<br />
<br />
I have added some code to display any errors.<br />
DoCmd.TransferSpreadsheet acImport, 10, RS07ImportDataAddGrp0003, &quot;M:\Web\Att\2020-05-01@17.<wbr />34-Co-op Camp Registration 35th GA.xlsx&quot;, False, &quot;&quot;<br />
<br />
This produces Error: 'An expression you entered is the wrong data type for one of...'<br />
<br />
DoCmd.TransferSpreadsheet acImport, 10, &quot;07_IMPORT_DATA&quot;, &quot;M:\Web\Att\2020-05-01@17.<wbr />34-Co-op Camp Registration 35th GA.xlsx&quot;, False, &quot;&quot;<br />
This produces Error: &quot;Field 'F1' doesn't exist in destination table '07_IMPORT_DATA'....<br />
<br />
The last Error is correct. &nbsp;There is no such field.<br />
<br />
Thanks,<br />
Bob C.
</div>


<div>
I am thinking that something is wrong in the Excel...can you try the code with some other Excel ?
</div>


<div>
Hi John,<br />
<br />
Unfortunately I don't have any way to do that.<br />
<br />
Instead of using the TrasferSpreadsheet Method to avaoid unecessary delay I am using Late Binding Code that I have been using in the past.<br />
<br />
I will keep a reference to this Question and come back to it sometime in the future.<br />
<br />
In the meantime I'm going to close it with your suggestion as the solution.<br />
<br />
Thanks,<br />
Bob C.
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have been using 'Late Binding' to import data froman Excel File to &nbsp;an Access 2016 Table.<br />
<br />
Im now trying to create a new import function.<br />
<br />
A while ago John Tsioumpris and Mark Edwards suggested the TransferSpreadsheet method.<br />
<br />
I have coded it as follows but it doesn't import anything.<br />
<br />
DoCmd.TransferSpreadsheet acImport, 10, RS07ImportDataAddGrp0003, &quot;M:\Web\Att\2020-05-01@17.<wbr />34-Co-op Camp Registration 35th GA.xlsx&quot;, False, &quot;&quot;<br />
<br />
The Excel Spreadsheet has 2 Columns (A &amp;&nbsp;B) with 121 Rows although in production the number of rows won't be known<br />
<br />
Can you tell me what is wrong with the systax of the command?<br />
<br />
Thanks,<br />
Bob C.
</div>
</div>


Hi Experts,

I have been using 'Late Binding' to import data froman Excel File to  an Access 2016 Table.

Im now trying to create a new import function.

A while ago John Tsioumpris and Mark Edwards suggested the TransferSpreadsheet method.

I have coded it as follows but it doesn't import anything.

DoCmd.TransferSpreadsheet acImport, 10, RS07ImportDataAddGrp0003, "M:\Web\Att\2020-05-01@17.34-Co-op Camp Registration 35th GA.xlsx", False, ""

The Excel Spreadsheet has 2 Columns (A & B) with 121 Rows although in production the number of rows won't be known

Can you tell me what is wrong with the systax of the command?

Thanks,
Bob C.

Access 2016 Import Excel Data

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.