Ok, I will check it.
http://www.valentina-db.com/bt/view.php?id=8557

It seems you do the import with "inHasColumnHeader as Boolean = false" param. So every row is treated as data.

You are funny Ivan...

I use true for that parameter, do not worry! If not, I would not post and ask such question here.
If you think it works correct, let it be – I already built my own proofing workaround.

I'm afraid you get me wrong. I mean - current + new one tests work fine - no problems. But "false" as param causes to exactly your result.
Ok, could you send me that file for testing + all the params you are calling with VCursor.importText?

Do not worry Ivan, everything is ok.
I also wondered but most of the files I get have a newline and a blank line after the header line.
Attached the file I tested with and here the XOJO code:

Dim impCSVCurs As New VDBCursor(vDBDatabase, "SELECT "_

+ "import_TEMP.portalID AS portal_id, "_

+ "import_TEMP.portalGroupID AS portal_orderGroupId, "_

+ "import_TEMP.productArtikelnummer AS portal_sapNumber, "_

+ "import_TEMP.productBarcode AS portal_ean, "_

+ "import_TEMP.foto360 AS portal_360g, "_

+ "import_TEMP.spaceMan AS portal_apollo, "_

+ "import_TEMP.spaceManPacked AS portal_withPackaging, "_

+ "import_TEMP.spaceManUnPacked AS portal_noPackaging, "_

+ "import_TEMP.productTRAY AS portal_tray, "_

+ "import_TEMP.productKW AS portal_kw, "_

+ "import_TEMP.orderExpress AS portal_express, "_

+ "import_TEMP.sampleDelivery AS portal_sampleDelivery, "_

+ "import_TEMP.sampleBack AS portal_sampleReturn, "_

+ "import_TEMP.removeFlag AS portal_storno, "_

+ "import_TEMP.portalMail1 AS portal_eMail1, "_

+ "import_TEMP.portalMail2 AS portal_eMail2, "_

+ "import_TEMP.portalInstruction AS portal_photoInstruction "_

+ "FROM import_TEMP;", 2, 3, 1)



impCSVCurs.ImportText(classicFileObject, Chr(59), Chr(10), "UTF-8", True, 0)

impCSVCurs = Nil

Thank you.