Power Platform Community Forum Thread Details

Hi,

I have this kind of error with Sql Action, I would like to insert rows from Excel File to Access Database in Azure SQL.

I don't understand because the data are very simple in my Excel Tab :

DateAction CodeCegid qte
03/02/2017 12599 12
04/02/2017 12596 50
05/02/2017 19692 13
06/02/2017 17511 5

Access Table : Import

Following the error message :

RAISON

ENTRÉES

SORTIES

En-têtes
{ "Pragma": "no-cache", "x-ms-request-id": "084c6d29-5f12-4487-9bfd-bff437dc6d8d", "Cache-Control": "no-cache", "Date": "Sat, 11 Feb 2017 11:02:39 GMT", "Server": "Microsoft-IIS/8.0,Microsoft-HTTPAPI/2.0", "X-AspNet-Version": "4.0.30319", "X-Powered-By": "ASP.NET", "Content-Length": "141", "Content-Type": "application/json; charset=utf-8", "Expires": "-1" }
Corps
{ "status": 400, "message": "Incorrect syntax near ')'.\r\n inner exception: Microsoft SQL: Incorrect syntax near ')'.", "source": "127.0.0.1" }

Categories: