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:
- 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.