Update or Insert data

Goal: Setup a workbook formula that pushes the data into the database (use the given connection string).

Input: Download table with data from here.

Connection String: Data Source=(local)\SQLEXPRESS;Integrated Security=True;User ID=SheetKraft;Initial Catalog=testdb1

Table Name: "dbo"."product"

Hint:

1. Use the UI ExportToDatabase.SK, connect to the relevant datasource using above given connection string.
2. Search for the given table by clicking on Table Name [horizontal dotted button].
3. Select the relevant Operation.
4. Check the columns to be exported.
5. You can also check the output checkbox (for any column) if you want see the uploaded data.