<div>
Thanks. It works after creating import specification
</div>


Thanks. It works after creating import specification

<div>
<div class="content wysiwyg-content">
I am trying to import csv file into Access table using the following codes. For some reason, it only imported the first column and populated errors for other columns/fields in error table. I got the same issue when using macros too. Can you please help? Thanks<br />
<br />
Sub TransferFile()<br />
DoCmd.TransferText acImportDelim, , &quot;MtTableName&quot;, &quot;C:\Automate\IA\OrigFile.c<wbr />sv&quot;, True, &quot;&quot;<br />
End Sub<br />

</div>
</div>


I am trying to import csv file into Access table using the following codes. For some reason, it only imported the first column and populated errors for other columns/fields in error table. I got the same issue when using macros too. Can you please help? Thanks

Sub TransferFile()
DoCmd.TransferText acImportDelim, , "MtTableName", "C:\Automate\IA\OrigFile.csv", True, ""
End Sub


ImportError from Transfer CSV file into Access 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.