The date in the csv is relational, and I want to join on the ASXCode from the Confirmations csv with the Description from the Cash CSV that contains the trading code within other text. Example ConfirmationCSV.Code = "ADH.ASX" and CashCSV.Description = "BUY ADH.ASX 458 AUD 2.15 34505627 NT1701659-002"

sCommand = "select [" & sConfirmationTblNoFullStops & "].[Code] as ASXCode, [" & sConfirmationTblNoFullStops & "].[Date], [" &
sConfirmationTblNoFullStops & "].[Quantity], [" & sConfirmationTblNoFullStops & "].[Action] as Type, [" & sConfirmationTblNoFullStops &
"].[Avg# price]" & ' replace . char with #
" as Price, [" & sConfirmationTblNoFullStops & "].[Fees] as TradingFee, [" & sConfirmationTblNoFullStops & "].[Settl# value] as Cost " &
", [" & sCashTblNoFullStops & "].Date as SettlementDate, [" & sCashTblNoFullStops & "].[Description] " &
"from [" & fiConfirmationsFile.Name & "] " &
"inner join [" & sCashTblNoFullStops & "] on ([" & sConfirmationTblNoFullStops &
"].[Code] like '%' + [" & sCashTblNoFullStops & "].[Description] + '%')" &
" where action='buy' "

Using oledbadapter As New OleDbDataAdapter(sCommand, sConnConfirmationsCSV)

MsgBox(sCommand) 'testing here
oledbadapter.Fill(dtStocks)

oledbadapter.Dispose()

End Using
returns no results - the logic is there for the results to be pulled

and

using Concat('%', [" & sCashTblNoFullStops & "].[Description], '%') returns the following exception : System.Data.OleDb.OleDbException: 'Undefined function 'CONCAT' in expression.

Has anyone got a working example of reading from CSV and performing a join based on a like please? I don't want to iterate and poplulate the resulting table filled from the adodbdatareader