Update Existing

Goal: Setup a workbook formula that pushes the data into the database using UpdateExisting operation(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.
  6. If some data already exist in the table then an Ignore will be shown and rest of the data will be updated and pushed into the database.