Good afternoon everyone, i'm using the TransferDatabase function to import a CSV file into one of my table database and when the customer includes " (inch) character in one of the field who i'm importing this transform the imported string. Here the example and what i use to import :
Original String from CSV file : 6" LINE FM FW-427 TO P47278 TEST HEADER
How the string is show in my table : "6"" LINE FM FW-427 TO P47278 TEST HEADER"
I use: [DoCmd.TransferText acImportDelim, "04Class Template1 Import Specification", "loadfile_FLOC_Class", Me.my_loadfile, False]
Thank you for kindly support.