<div>
Something like:<br />
<br />
DoCmd.TransferText TransferType:=acLinkDelim,<wbr /> TableName:=&quot;tblImport&quot;, _<br />
&nbsp; &nbsp; FileName:=&quot;C:\MyData.csv&quot;,<wbr /> HasFieldNames:=true
</div>


Something like:

DoCmd.TransferText TransferType:=acLinkDelim, TableName:="tblImport", _
    FileName:="C:\MyData.csv", HasFieldNames:=true

<div>
<div class="content wysiwyg-content">
I have this line of code which works fine for importing an Excel file into a table:<br />
<br />
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, &quot;tblTempImport&quot;, Me.FileList, True<br />
<br />
But if the file is a csv file how do I code the line?<br />
<br />
--Steve
</div>
</div>


I have this line of code which works fine for importing an Excel file into a table:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTempImport", Me.FileList, True

But if the file is a csv file how do I code the line?

--Steve

How import csv file into a table

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.