If it can help, following is my query result which I use to export in CSV with the following instruction:
Docmd.TransferText acExportDelim, , "008_EQUI_Temp", myfilename, True
The records which are wrongly transformed are in the column "ManufSerialNo" in red color, all the others are well...