Share
Report
2Hi,
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
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
- CodeBadRequest
ENTRÉES
- Nom de la tableAccess.Import
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:
I have the same question (0)
All responses (
Answers (
