Save Menu

Save Menu

Save
The button saves table changes back to a database and reloads the data.
The button is enabled if the changes can be saved.
Check SQL
The button shows the SQL code that is used to save changes.
This code can be used to save the changes or troubleshoot issues using tools like SQL Server Management Studio.
The button is enabled if the changes can be saved.
Filter Changed Rows
The menu allows filtering new and changed rows.
This feature works for the tables that support saving changes (only for those tables the add-in tracks changes).
For tables saved by merge only filtering new rows is available.
Merge
The button merges table data back to a database (inserts new rows and updates existing ones) and reloads the data.
The button is enabled if the data can be merged.
Check Merge SQL
The button shows the SQL code that is used to merge data.
The button is enabled if the data can be merged.
Save Worksheet Tables
The button saves changes of all worksheet tables back to a database and reloads the data.
The button is enabled if the changes can be saved.
Save Workbook Tables...
The button displays the Save Data Changes dialog box.
See below.
Save Table Data As...
The button allows saving Excel table data to a CSV file.
Only filtered row and visible column data are saved.
Save Query Table As...
The button allows saving query data to a CSV file.
The data are loaded from a data source, not from an Excel table.

Required Conditions for Saving Changes

Changes of database tables can be saved to a database without any coding.

But,

  • A user must have INSERT, UPDATE and DELETE permissions on the table.
  • Excel table row numbers must be turned on.

To turn on row numbers, run the Excel Data, Connections, Properties dialog box and check Include row numbers.

Alternatively, run the SaveToDB, Reload, Configure Query dialog box.

Changes of Excel table data loaded from views, stored procedures, SQL codes, HTTP queries and text files can be saved to a database if

  • The feature is configured in a database.
  • A user has permissions to INSERT_PROCEDURE, UPDATE_PROCEDURE and DELETE_PROCEDURE objects.
  • Excel table row numbers are turned on.

The changes can be saved into a base database table without coding or into multiple tables using custom stored procedures or SQL codes.

See Configuring saving changes.

Save Data Changes Dialog Box

The Save Workbook Tables button displays the Save Data Changes dialog box.

Save
The button saves changes and reloads data of the selected tables.
Cancel
The button stops saving and closes the dialog box when the saving is not running.
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.