How to combine two lines with the Jet.OLEDB.4.0 provider

Question

I pass the request to an internal application that launches this request and returns the result, the connection to the CSV file, and I connect to the provider = Microsoft.Jet.OLEDB.4.0

I would like to join the rows in one column, but I get an error.

Is it possible to do this, does anyone know how to do this?

An example of what I am doing:

select 
 PurchaseOrderNo, 
 PurchaseOrderDate, 
 Description, 
 Quantity,
 ContractName + 'delimiter' + ContractNo as LinePrimaryKeys
from [POImport baseline.csv]

error: - Error. The provider could not determine the double value. For example, a row has just been created, the default value for the Double column was not available, and the consumer has not yet set a new Double value.

From another reading, it can be seen that both values ​​that I connect are recognized as strings.

,   PurchaseOrderNo + 'delimiter' + ContractNo LinePrimaryKeys   PurchaseOrderNo + 'delimiter' + PurchaseOrderNo LinePrimaryKeys

. , ?

. ContractName + 'cn' + CAST (ContractName nvarchar (50)) LinePrimaryKeys

Answer 1

+ &.

& , + () . & .

select 
 PurchaseOrderNo, 
 PurchaseOrderDate, 
 Description, 
 Quantity,
 PurchaseOrderNo & 'delimiter' & ContractNo as LinePrimaryKeys
from [POImport baseline.csv]