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:
- Use the UI ExportToDatabase.SK, connect to the relevant datasource using above given connection string.
- Search for the given table by clicking on Table Name [horizontal dotted button].
- Select the relevant Operation.
- Check the columns to be exported.
- You can also check the output checkbox (for any column) if you want see the uploaded data.
- 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.