insert database as field

[david_89_]

Hi,


I have a datasource in an excel file and I am trying to insert a database as a field, where the customer number is equal to a mergefield "customer number"

the code is the following:

{ DATABASE \d "C:\\Statement\\Datasource.xlsx" \s "SELECT `Client Billing Document Number` AS `No Doc`, FORMAT(`Invoice Date`, 'dd/MM/yyyy') AS `Fecha Doc`, FORMAT(`Due Date`, 'dd/MM/yyyy') AS `Vencimiento`, FORMAT(`Client Document Currency Balance`, '##,###,##0.00') AS `Importe`, `Client Document Currency` AS `Moneda` FROM `Data$` WHERE ((`Debtor Number` = '50010117')) ORDER BY `Invoice Date`, `Due Date`" \l "37" \b "51" \h }

the mailmerge works, but it gives an error when it tries to open the datasource.

Error has occurred: Data type mismatch in criteria expression.

Word was unable to open the data source

A field calculation error occurred in record 1

Any ideas?

Thank you in advance.