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
DoCmd.TransferText acImportDelim, , "MtTableName", "C:\Automate\IA\OrigFile.csv", True, ""