Insert All

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


  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 error will occur and no output will be generated