SaveToDB Save Menu

Save: The button saves data changes back to a data source and reloads the data.
The button is enabled if the object supports saving changes.
The add-in allows saving changes for database tables, views and stored procedures, configured REST API queries, OData EntitySets, and DBGate objects.
Database developers can configure saving changes for any object.
Use the Check SQL button to check commands used to save current changes.
Check SQL: The button shows SQL, OData, or REST API commands used to save changes of the active table.
Use this feature to troubleshoot saving issues.
Also, use the generated commands to save changes in a third-party tool like SQL Server Management Studio if you use a free SaveToDB edition.
The button is enabled if the object supports saving changes.
Filter Changed Rows: The menu allows filtering new and changed rows.
The add-in tracks changes if the object supports saving changes.
You can filter new rows if the object supports merging data.
Merge: The button merges data to a database, i.e., inserts new rows, updates existing ones, and reloads the data.
You can use this button to repeat merging data made with the Data Merge Wizard.
Database developers can configure merging data also.
Check Merge SQL: The button shows commands used to merge data.
Save Worksheet Tables: The button saves changes of all worksheet tables and reloads the data.
The button is enabled if any worksheet table supports saving changes.
Save Workbook Tables...: The button displays the Save Workbook Tables dialog box that allow saving changes of the selected tables.
Save Table Format: The button saves the active table format to a database or a data service.
This button is enabled if developers configure saving table formats. See Developer Guide.
Use the Reload Table Format button of the Reload Menu to restore table formats from a database or a data service.
You can also use the Table Format Wizard to save and restore the formats of the selected tables.
Save Table Data As...: The button allows saving Excel table data to a CSV file, HTML page, or INSERT commands.
The add-in saves filtered rows and visible columns only.
So, you can easily prepare data to export.
Save Query Table As...: The button allows saving active query data to a CSV file, HTML page, or INSERT commands.
The add-in loads data from a data source, not from an Excel table.