Batch Replace

Goal: Setup a workbook formula that pushes the data into the database using BatchReplace 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_batchkey"

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.