<div>
&lt;No Points wanted&gt;<br />
<br />
&quot;F1&quot; means &quot;Field1&quot;, ...a generic name for the field if you forget to use the HasFieldNames argument of the TransferSpreadheet Action...<br />
...or if the data has no field names.<br />
<br />
So capricorn1's syntax will work just fine for you.<br />
<br />
See the VBA Help Files for the TransferSpreadsheet Action/Method, ...for more detailed information.
</div>


<No Points wanted>

"F1" means "Field1", ...a generic name for the field if you forget to use the HasFieldNames argument of the TransferSpreadheet Action...
...or if the data has no field names.

So capricorn1's syntax will work just fine for you.

See the VBA Help Files for the TransferSpreadsheet Action/Method, ...for more detailed information.

<div>
As usual, Capricorn1 gets me right out of the woods on the first try!
</div>


As usual, Capricorn1 gets me right out of the woods on the first try!

<div>
<div class="content wysiwyg-content">
I'm trying to import an Excel file into a Table in my application using<br />
<br />
DoCmd.TransferSpreadsheet , , &quot;Ledger_Import&quot;, strFileName<br />
<br />
It is giving me an error that says &quot;F1 is not in Ledger_Import&quot; but there is no F1 column heading in the Excel sheet. Can I use a saved import specification to identify which columns are text and which are numbers and to make the upload go smoothly? Any other suggestions welcomed.<br />
<br />
Thanks.
</div>
</div>


I'm trying to import an Excel file into a Table in my application using

DoCmd.TransferSpreadsheet , , "Ledger_Import", strFileName

It is giving me an error that says "F1 is not in Ledger_Import" but there is no F1 column heading in the Excel sheet. Can I use a saved import specification to identify which columns are text and which are numbers and to make the upload go smoothly? Any other suggestions welcomed.

Thanks.

Import Excel Using Saved Import

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.

Microsoft Development

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.