Skip to content


Add Update SQL Rows

Denise asked 9 years ago
We would like to allow users to add and update rows from a SQL Server table using SmartConnect. In the mappings, I see the option to ‘Update’, but if I uncheck it, it attempts to read the rows. Is it possible to allow insert/update (and possibly delete) from Excel to SQL using SmartConnect?
Best Answer
Lorren answered 9 years ago

If you need to do an update or insert then it would be better to write a stored procedure to handle that case and use that stored procedure as your destination.

The Checkbox for Update If Exists is used for setting the flag on Dynamics GP transactions or CRM/ as the API's for those products have that scenario handled.  With the SQL Table or SQL Stored Procedure destinations you are effectively handling the business case/logic.


If you would like to submit an answer or comment, please sign in to the eOne portal.