cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mnoury
Level: Powered On

error SQL with Insert row from Excel File : " incorrect syntax near ')' "

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
 
Capture d’écran 2017-02-11 à 18.21.34.png
 
Following the error message :
 
RAISON
  • Code
    BadRequest

ENTRÉES
  • Nom de la table
    Access.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" }
1 REPLY 1
mnoury
Level: Powered On

Re: error SQL with Insert row from Excel File : " incorrect syntax near ')' "

 

I tested it with a Sharepoint List instead of one Excel File and I have the same error

 

"status": 400, "message": "Incorrect syntax near 'inserted'.\r\n inner exception: Microsoft SQL: Incorrect syntax near 'inserted'.", "source": "127.0.0.1"

 

Should I try to recreate the connection with Azure SQL (Access webapp database) ?

 

Any help with this would be greatly appreciated!

Thanks

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users online (4,793)