SaveToDB 7

SaveToDB 7

Getting Started

Welcome to SaveToDB, a Microsoft Excel add-in for working with databases, the web, and text files.

SaveToDB allows loading data into Microsoft Excel from different data sources and saving the data changes back to data sources.

SaveToDB supports the following database platforms:

  • Microsoft Azure SQL Database
  • Microsoft SQL Server
  • Microsoft SQL Server Compact
  • Oracle Database
  • IBM DB2
  • MySQL and MariaDB
  • NuoDB
  • PostgreSQL
  • SQLite

SaveToDB allows loading data from text files, web pages and web services including OData web services and saving data changes to OData web services.

SaveToDB supports the following web and text data formats:

  • XML
  • JSON
  • HTML
  • CSV

The SaveToDB add-in can be used right after install. Just run the Data Connection Wizard and connect to the desired data source.

You may change stored procedure and web query parameters, customize SELECT and WHERE field sets, and even save data changes to database tables and OData web services without any coding!

However, the real power of the add-in is uncovered when the user interface is customized on the server-side.

In facts, Microsoft Excel can be used as a feature-rich desktop client of database applications.

Microsoft Excel can be used as a primary or secondary client that delivers new opportunities to end users and can help companies to reduce the total cost of ownership.

The Microsoft Excel applications can be used

  • for working with data inside companies,
  • for sharing data with corporate partners, vendors, and customers (B2B),
  • for delivering data to consumers (B2C).

It is important that the end users can add and integrate different data sources themselves and can use all the power of Microsoft Excel: formulas, formats, views, charts and so on.

 

The best news is that Microsoft Excel coding is not required at all!

The SaveToDB add-in loads its configuration from a database. Even Microsoft Excel events are handled by stored procedures, SQL codes or web queries.

This approach allows database developers to create amazing client applications using database development skills only.

 

SaveToDB Framework allows developers to add an application infrastructure into a database in a couple of minutes.

Then generate the SaveToDB configuration workbook and edit the configuration tables using Microsoft Excel.

 

It is important that projects can be carried out step by step. The first application can be implemented very quickly with great results.

Moreover, new features can be added to a database as required. The SaveToDB add-in reloads new configuration, and end users have the new features in their workbooks.

 

You may start learning about SaveToDB on the following topics:

Main Ideas

Main Ideas for using SaveToDB add-in for Microsoft Excel

SaveToDB Edition Comparison

SaveToDB is a powerful add-in for working with databases in Microsoft Excel and a powerful platform for Microsoft Excel application development.

Personal and Enterprise editions have the same features but different prices and licenses.
Using SaveToDB Personal in companies and organizations is prohibited.

FeaturePersonalEnterprise
Loading Data  
Loading data from database tables, views, and stored procedures
Loading data from web pages and web services (HTML, CSV, XML, JSON, plain text)
Automatic loading multiples web pages (HTML, XML, JSON)
Loading data from OData data sources
Loading data from text files (HTML, CSV, XML, JSON, and plain text)
Saving Data  
Saving data from any data source to a database using built-in procedures
Saving data from any data source to a database using Publish Wizard
Saving data from any data source to a database using Data Merge Wizard
Saving data from any data source to a database using custom event handlers
Saving data from any data source to a database using custom SQL code
Saving data from any data source to a database using custom stored procedures
Saving data from any data source to a text file (CSV, HTML)
Saving data to OData services
Querying Data  
Changing queries using the ribbon Query List
Changing stored procedure parameters using the ribbon Query Parameters
Changing select where fields using the ribbon Query Parameters
Changing web-query parameters using the ribbon Query Parameters
Changing data table views using the ribbon Table View list
User Interface Features  
Editing Excel tables using pivot tables
Saving and restoring Excel table views
Saving and restoring pivot table views
Selecting active table rows (cursors)
Updating named cells with active table row values and back (fields)
Showing images from databases and the web
Excel Application Development  
Loading Excel application configurations from databases
Loading Excel table and pivot table formats from databases
Saving excel table formats to databases
Saving pivot table formats to databases
Translating data table columns within Microsoft Excel to user's language
Customizing context drill-down queries to databases and the web
Customizing context macros and Windows shell commands
Customizing master-detail interfaces
Customizing ribbon Query List, Query Parameters, and Table Views
Customizing Excel formulas including DDE in views and stored procedures
Protecting Excel data and formulas using server handlers
Calling SaveToDB methods from VBA macros
Database Server Support  
Microsoft Azure SQL Database and Microsoft SQL Server
Microsoft SQL Server Compact
Oracle Database
IBM DB2
MySQL and MariaDB
NuoDB
PostgreSQL
SQLite
Licensing  
Commercial usex

Feature Overview

Data connection features:

  • Connecting to database tables, views, and stored procedures.
  • Connecting to Microsoft SQL Server, Microsoft Azure SQL Database, Microsoft SQL Server Compact, Oracle Database, IBM DB2, MySQL, MariaDB, NuoDB, PostgreSQL, and SQLite.
  • Connecting to web pages and web services, including OData web services, with full support for HTML, XML, JSON and CSV data formats.
  • Connecting to web pages and web services using authorization methods: Windows, Basic, Forms, OAuth 1.0, and OAuth 2.0.
  • Connecting to web pages and web services using authorization providers: Google, Facebook, LinkedIn, Twitter, Windows Live, Yahoo, and Yahoo API Key.
  • Connecting to text files in HTML, XML, JSON and CSV data formats.
  • Configurable database connection timeout.
  • Full support for copying and moving data tables inside or between workbooks.

Saving data changes:

  • Saving changes of data loaded from database tables back to a database without coding.
  • Saving changes of data loaded from database views, stored procedures, or SQL codes to a base table without coding *.
  • Saving changes of data loaded from database views, stored procedures, or SQL codes to a database using custom INSERT, UPDATE and DELETE SQL codes *.
  • Saving changes of data loaded from database views, stored procedures, or SQL codes to a database using custom INSERT, UPDATE and DELETE procedures *.
  • Saving changes of data loaded from OData web services back without coding.
  • Saving changes of data loaded from any data source on cell change events using custom stored procedures or SQL codes *,**.
  • Merging data loaded from any data source (database, the web, and text files) to a base table without coding *.
  • Merging data loaded from any data source (database, the web, and text files) to a database using custom stored procedures or SQL codes *.
  • Saving data calculated by Microsoft Excel formulas to a database *.
  • Checking the code used to save data changes from the Save menu.
  • Tracing SQL codes used to save data changes.
  • Configuring command timeout.
  • Caching Excel data changes to support closing workbooks before saving data to a database or a web service.
  • Using confirmation for reloading unsaved data, including support for native Excel refresh operations.
  • Full support of undo and redo operations (Ctrl-Z and Ctrl-Y).
  • Full support of adding, deleting, copying, and inserting table rows.
  • Full support of inserting and reordering table columns.
  • Full support of formula columns including the formula AutoComplete feature.

Query builder:

  • Changing database queries using the ribbon Query List.
  • Executing SQL codes, HTTP and text file queries using the ribbon Query List *.
  • Saving table formats of closed queries and applying saved formats when the queries are reopened.
  • Customizing SELECT fields for tables and views.
  • Changing WHERE filters of the table and view queries using the ribbon parameters.
  • Changing stored procedure parameters using ribbon parameters.
  • Customizing HTTP query parameter sets and changing HTTP query parameter values using the ribbon parameters.
  • Changing parameter values using the Query Parameters dialog box.
  • Populating parameter values depend on other parameter values.
  • Populating parameter values from user's history of parameter values.
  • Editing user's history of parameter values using the Parameter Values dialog box.
  • Configuring parameter value history limit.
  • Updating named cells with parameter values and backward updating parameters with changed named cells.
  • Defining Microsoft Excel formulas in views, stored procedures and SQL codes including DDE and RTD (Real-Time Data) formulas.

Wizards:

  • Connecting to databases, web pages, web services, and text files.
  • Creating database tables based on Microsoft Excel tables, and exporting Excel data to a database.
  • Merging data from any data source (databases, the web, text files) to databases tables.
  • Creating Microsoft SQL Server Compact databases.
  • Changing database connection for multiple Excel tables at once.
  • Installing SaveToDB Framework into databases on all supported platforms.
  • Generating workbooks for editing SaveToDB Framework configuration tables.
  • Saving table formats in databases and applying the formats in any workbook.

Configuring user interface using a database *:

  • Configuring the ribbon Actions menu to run context views, stored procedures, SQL codes, HTTP and text file queries, macros, and Windows Shell and CMD commands.
  • Configuring the context menu to run context views, stored procedures, SQL codes, HTTP and text file queries, macros, and Windows Shell and CMD commands.
  • Configuring the Query Parameters dialog box.
  • Configuring drill-down queries on the Double-Click event.
  • Configuring master-detail interfaces using SelectionChange event handlers.
  • Protecting Excel table values and formulas using Change event handlers.
  • Configuring query output targets: a sheet, the default web browser, data window, or an internal browser.
  • Generating HTML documents within a database, including ready-to-print official documents.
  • Configuring the ribbon Query List using database views.
  • Configuring table and view fields to customize WHERE filters via the ribbon.
  • Populating parameter values using views, stored procedures, and SQL codes.
  • Setting parameter values of the active query by call-back database queries (resetting forms, new document numbers and so on).
  • Updating named cells with query data.
  • Distributing Excel table formats of database objects from a database.
  • Translating database object names and descriptions to any language within Microsoft Excel using translation views.
  • Translating database object fields and parameters to any language within Microsoft Excel using translation views.

Useful features:

  • Saving data changes for a group of selected tables.
  • Reloading data for a group of selected tables.
  • Saving and applying named table views within Microsoft Excel.
  • Adding child windows on top or bottom, left or right side.
  • Auto-activating related child windows.
  • Auto-arranging windows.
  • Changing Microsoft Excel auto-filters using the row over the table.
  • Copying and inserting table rows.
  • Inserting dates into cells using the popup Calendar dialog box.
  • Auto-opening the last opened workbook at the Microsoft Excel startup.
  • Changing the SaveToDB tab name.

 

* Server-side configuration is required. SaveToDB Framework supports all the features.

** SaveToDB Personal, SaveToDB Enterprise, or a trial version is required.

Change History

Version 7.27, September 17, 2018

Bug Fixes:

  • Fixed conversion of SQL Server date type values to dates on filtered ranges.

Version 7.26, September 10, 2018

New features:

  • Support for Azure SQL Data Warehouse.
  • Support for tables with headers turned off.
    Note, if you create forms with such headers, update all SaveToDB installations to SaveToDB 7.26.

Improvements:

  • The add-in calls the INSERT procedures even for empty rows with the changed @rownum parameter value.
    This guarantees that your app gets the list of all rows with changed numbers.
  • Improved support for ODBC driver errors.
  • You may use the DoNotSave handlers to disable saving values of formula fields in the reload phase.
    Otherwise, the add-in saves the values of the formula columns to check for row changes before saving.

Bug Fixes:

  • Fixed bug on fields with special characters: .,;:'"`~+-*\/|<>[](){}=@%!?&#$
  • Fixed bug on inserting tables with RC address style.
  • Fixed bug of loading values started with a single quotation mark.

Version 7.25, July 25, 2018

Improvements:

  • Significantly improved speed of loading large datasets from MySQL and PostgreSQL.
    For example, it loads 400k records four times faster (about 10 seconds).

Version 7.24, July 11, 2018

Bug Fixes:

  • Fixed exception on adding form fields.

Version 7.23, June 22, 2018

The free SaveToDB Express edition is no longer available.

Existing users of the free edition may continue use it.

Version 7.22, June 18, 2018

Bug Fixes:

  • Fixed issues with the "Member not found" exception related to Sort and AutoFilter objects in Excel version 16.0.10228.20021.

Version 7.21, May 25, 2018

Improvements:

  • Improved JSON parser
  • Product Registration Wizard uses HTTPs

Bug Fixes:

  • Fixed SendFailure error with HTTPs TLS 1.2

Version 7.20, May 24, 2018

Improvements:

  • Updated Product Registration Wizard

Version 7.19.3, March 26, 2018

Improvements:

Bug fixes:

  • Fixed compatibility issues with PowerPivot.
  • Fixed issues with deleting named cells.

Version 7.19.2, March 21, 2018

Improvements:

  • Update SQLite .NET Provider 1.0.108.0
  • Improved detecting next page links in HTML pages.
  • Converting dates in the "dd MMM yyyy" format from text and web data sources to dates.

Bug fixes:

  • Fixed installation issues.
  • Fixed error messages on connecting SQLite databases with passwords.
  • Fixed compatibility issues with PowerPivot.

Version 7.19, March 12, 2018

Breaking changes:

  • The add-in uses Excel validation lists to convert id to names.
    The behavior is the same as for ValidationList event handlers configured in a database.
    For example, if you specify a validation list as a table with two columns like ID and NAME, then the add-in replaces ID values to NAME values.
    To prevent converting, use validation lists with one column.
  • The add-in converts IDs to names for columns with SelectionList handlers if the source list has two columns.
    So, now SelectionList and ValidationList handlers have the same features except the add-in does not add Excel validation lists to SelectionList columns.
    To prevent converting of column values, specify SelectionList queries with one column results.

Improvements:

  • SaveToDB Framework 7.19.
    The framework includes redesigned upgrade packages.
    The framework for Microsoft SQL Server removes users from the framework roles on uninstalling.
    The batch files allow executing from protected folders and read-only media.
  • Improved Workbook Information dialog box.
    It saves and restores last user settings.
  • Fields HANDLER_CODE and SELECT_CODE based on tables and views allow using functions.
    For example, a query with YEAR([Date]) selects a unique list of years.

Bug fixes:

  • Fixed bug of incorrect column orders of validation list values from tables.
  • Fixed bug of the Save Query As action for tables without connections.
  • Fixed bug of creating validation lists based on tables with dashes in names.

Version 7.18, February 21, 2018

Improvements:

  • Improved speed of converting formulas in filtered tables.
  • Ignoring new SaveToDB 8 handler types.

Bug fixes:

  • Fixed System.OverflowException with MySQL.
  • Fixed translations of columns with case differences only.

Version 7.17, February 7, 2018

Improvements:

  • Updated Product Registration Wizard.
  • The UserAgent header contains the default value: SaveToDB.

Bug fixes:

  • Fixed converting text formulas in hidden rows.

Version 7.16, January 15, 2018

Improvements:

  • Updated SaveToDB SDK 7.16.
  • Updated SaveToDB Framework 7.16 for Microsoft SQL Server.
  • SQL Server and SQL Server Compact objects can use parameters of timestamp and rowversion types.
  • Event handlers can use the _rownum parameter to get row numbers independently on the Excel UI language.
  • The add-in does not apply default formatting to read-only fields.
  • The add-in does not apply default formatting and validation to fields of the datetimeoffset type.

Bug fixes:

  • Fixed possible issues with fields and parameters that contains non-alpha-numeric characters in SQL Server.
  • Fixed possible stability issues with Excel 2013-2016.
  • Fixed possible issues with pivot tables.
  • Fixed issues with loading SQL Server Compact configurations (7.15 only).
  • Fixed issues with inserting a new connected table on another worksheet.
  • Fixed ignoring last column values in table fields.
  • Fixed removing leading zeros in fields of variant types.
  • Fixed exceptions with converting TimeSpan to DateTime in the cell_date_value parameter.
  • Fixed exceptions with converting 0000-00-00 00:00:00 to dates in MySQL if Allow Zero Datetime=False or Convert Zero Datetime=False.

Version 7.15, November 27, 2017

Breaking changes:

  • The add-in does not protect cells with more than 32767 characters.
    Now it generates the simple code like SELECT * FROM <table> for tables with column data types like varchar(max), string, text, or CLOB.
    You may exclude fields with longer values in Excel directly.

Improvements:

  • The add-in restores ribbon fields for tables and views with the query list.
  • The add-in restores worksheet tab colors for newly connected tables using stored formats in a database.
  • The SQL execute wizard allows changing a transaction mode.

Bug fixes:

  • Fixed configuration loading for Microsoft SQL Server 2005.
  • Fixed configuration loading for Microsoft SQL Server 2000.
  • Fixed SQL parameter configuration loading for Microsoft SQL Server.
  • Fixed SQL parameter configuration loading for parameters with brackets used in the HANDLER_CODE and SELECT_CODE fields.
  • Fixed loading parameter values with leading spaces in the HANDLER_CODE and SELECT_CODE fields for the VALUES type.
  • Fixed showing procedure parameter values at the ribbon for Oracle Database.
  • Fixed loading SQL parameter values at the ribbon for Oracle Database.
  • Fixed losing the List Editor task pane after adding rows.
  • Fixed showing exception messages on unlocking workbooks.

Version 7.14, November 8, 2017

New features:

  • New Change Tracking Framework for SQL Server.
    You may download, install, and use the framework for free with the SaveToDB Express.
    You may download the Change Tracking Framework for SQL Server e-book.
  • SelectionChange and ContextMenu handlers in task panes.
  • Configuring event handlers for event handlers.
  • Configuring parameters of SQL codes like stored procedure parameters.
  • Configuring translation of object and column names for _taskpane event handlers.
  • Task pane context menu to hide table columns.

Improvements:

  • The data language list in SaveToDB Options includes languages that may use the international keyboard layout (De, Es, Fr, It, Sv, Ja, Zn).

Bug fixes:

  • Converting parameters to values in SQL codes like @param= @param.
    Remove spaces before the equal sign to keep the parameter name as is.
  • Converting '= NULL' to 'IS NULL' in SQL codes used to execute stored procedures.

Version 7.13, November 3, 2017

New features:

  • New ready-to-use planning application with Microsoft Excel and SQL Server.
    You may download, install, and use the application for free.
    You may find example workbooks in the Wizards, Workbook Templates and Examples menu also.
    You may download the Planning Application with Microsoft Excel and SQL Server e-book.
  • Edit procedures may use the json_columns and json_values parameters to get all table columns and row values in JSON arrays.
    This feature allows implementing procedures to save changes in dynamic tables.

Improvements:

  • Updated examples in the Wizards, Workbook Templates and Examples menu.
  • You may hold Ctrl to reset authorization for HTTP requests.
  • Event handlers with the _reload option reload validation lists also.
  • Added JSONP parser.
  • Added PartialHTML parser (HTML inside JSON and JSONP).
  • Improved HTML parser.
  • Edit procedures may use the TableName and table_name parameters like event handlers.

Bug fixes:

  • Error converting string values to dates and numbers for variant types.
  • Losing conditional formattings for queries with errors in SQL codes.
  • Losing conditional formattings after AccessViolationException.
  • Errors with HTTPS requests that support tls12 only.
  • Parser errors for quotes in JSON.
  • NullReferenceException while loading bad event handler configurations.
  • Incomplete value lists in Oracle Database.
  • Registration wizard WebException in the offline mode

Version 7.12, September 7, 2017

New features:

  • Rotating values of Icon Sets on double-clicks.
    This feature allows implementing CheckBoxes in Excel.
    Use numbers to define ranges, not percents.

Bug fixes:

  • Losing ValidationLists on creating detail queries on worksheets.
  • Issues with saving OData data due to bad relative EditLinks.
  • Double requests for OData with basic authentication.

Version 7.11, August 23, 2017

Bug fixes:

  • Issues with Save All Sheet Tables.

Version 7.10, August 22, 2017

Bug Fixes:

  • Issues with registering products.
  • Issues with loading OData models.
  • Issues with decoding deflate web data.
  • Exception messages on resizing diagram windows.
  • Errors with saving table formats to Microsoft SQL Server databases.
  • Errors with calling Oracle Database procedures.
  • Converting string values to numbers in validation lists.

Version 7.9, August 1, 2017

New features:

  • Azure Active Directory integrated authentication
  • Azure Active Directory password authentication

Improvements:

  • SQL Server date columns are selected as is, without casting to the DateTime type.
    So, the add-in generates SELECT codes like SELECT * FROM <table> for such tables.
    The add-in converts loaded string values in the YYYY-MM-DD format to Excel dates after loading data.

Bug fixes:

  • Issues with connections using DSN.
  • Losing StopIfTrue = False in conditional formats.
  • Exception messages on restoring conditional formats.
  • Exception messages on copying formats for tables with column change handlers.
  • Exception messages on refreshing empty tables with updatable form fields.
  • Exception messages on refreshing pivot tables.

Version 7.8, July 5, 2017

Improvements:

  • Updated registration wizard
  • Updated installer
  • Improved detecting of updatable views for SQL Server
  • Showing columns of historical prices as OHLCV by default

Bug Fixes:

  • Converting IP-addresses to numbers
  • Exception messages on renaming pivot tables

Version 7.7, May 31, 2017

Licensing Changes

  • Removed limit of loading multiple web pages in SaveToDB Express.
  • Removed limit of updatable cursor fields in SaveToDB Express.

New Features:

  • New parameters of XML and JSON parsers:
    CollapsedNodes, SkippedNodes, IgnoredTags, NoSourceHeaders, AsIs, and RowValues

Improvements:

  • Updated set of suggested URLs for loading stock quotes, historical and intraday stock prices, option chains and futures from Yahoo Finance, Google Finance, and MSN Money.
  • Special processing of datetime values of historical prices from MSM Money.
  • Special processing of datetime values of option chains from Yahoo Finance.
  • HTML parser supports multiple tables in the /RootPath option.
  • Possibility to activate the add-in using the activation files in virtual environment.
  • Removed option 'Single Line SQL for SQL Server.' The add-in always generates standard SQL commands.
  • Suppressed error messages when DisplayAlerts = False.
  • Improved documentation.
  • Improved error diagnostics.

Bug Fixes:

  • Missed URLs in the Query Parameters dialog box title.

Version 7.6.2, May 15, 2017

Bug Fixes:

  • Wrong calls of event change handlers on changing headers and deleting rows over the tables (version 7.6 only).

Version 7.6, May 11, 2017

Improvements:

  • Support of ODBC Driver 13 for SQL Server
  • Improved documentation
  • Improved error diagnostics

Bug Fixes:

  • Installer issues with updating previous versions.
  • Lost of ribbon values of context parameters from the Edit Parameters form.
  • Missing calls of cell change event handlers on deleting the last rows.

Version 7.5, May 5, 2017

New Features:

  • Spanish translation

Improvements:

  • Redesigned msi installer.
  • New context parameters of cell change event handlers: @ChangedCellAction and @changed_cell_action.
    The parameters get values: CellChange, RowInsert, and RowDelete.

Bug Fixes:

  • Wrong detection of user-defined types in Microsoft SQL Server.
  • Publish wizard issues for tables without connections.
  • Web connection issues.
  • Incorrect behavior of setting the IsRibbonField property from VBA.
  • Missing calls of cell change event handlers on adding and deleting rows.

Version 7.4, April 5, 2017

Improvements:

  • Improved parsing JSON data.
    The parser supports * as a property name in the rootPath parameters.
    For example, try to load futures data from the Yahoo Finance website using the URL:
    https://query1.finance.yahoo.com/v10/finance/quoteSummary/CK18.CBT?modules=futuresChain;rootpath=quoteSummary.result.futuresChain.futuresChainDetails.*
  • HTML parser converts string values with % to numbers and "n.a." values to empty values.

Bug Fixes:

  • Lost of authorization data of HTTP requests.
  • Lost of rootPath parameter values of HTTP requests.

Version 7.3.2, March 31, 2017

Bug Fixes:

  • Updating non-string ribbon parameters with NULL on changes of parameter named cells.

Version 7.3.1, March 28, 2017

Bug Fixes:

  • Lost of the SaveToDB tab in new installations.
  • Lost of Encrypt and TrustServerSertificate options in the SQL Server .NET provider.

Version 7.3, March 27, 2017

New Features:

  • The add-in supports multiple values in ribbon parameters for tables and views.
    To select multiple values, click on the Query Parameters group button and click on the "..." button to launch a new editor of multiple values.
    Multiple values are translated to the WHERE <field> IN (<value>, ..., <value>) clause.
  • The add-in supports multiple values for string parameters of stored procedures.
    The add-in passed multiples values as (<value>, ..., <value>).
    For example, a select stored procedure has a currency string parameter and a view that populates the parameter values like (1, 'USD'), (2, 'EUR'), (3, 'GBP').
    If a user selects USD only, the add-in calls the procedure with '1'. If the user selects [USD,EUR], the add-in calls the procedure with the '(1,2)' value.
    Be careful with SQL injection using this technique. The best way is to accept integer and date multiple values only, and check the input values like this:
    IF LEFT(@param, 1) = '(' AND RIGHT(@param, 1) = ')' SET @param = SUBSTRING(@param, 2, LEN(@param) - 2)
    IF @param IS NOT NULL AND @param LIKE '%[^-0-9.,'' ]%' SET @param = NULL

Improvements:

  • Improved error diagnostics.

Bug Fixes:

  • Lost of add-in metadata on deleting multiple worksheets with VBA at once.
  • Showing the SaveToDB Enterprise edition as SaveToDB Express in the About Product dialog box.

Version 7.2, March 20, 2017

The trial version requires registration. The trial period remains the same, 30 days.

New Features:

  • The SQL Server Management application to manage logins, users, roles, and permissions in SQL Server and SQL Azure databases.
    You may launch the application from the query list in the Data Connection Wizard.
    The application can be used by database administrators and business users.
  •  Developer Guide 7.2 in the Workbook Templates and Examples menu.
    The guide shows new features for VBA developers.
  • Configuration tables may contain pseudo-SQL codes like
    [+|-][@]<Field>[,...]]
    All fields are used in SELECT.
    Fields with @ are used in WHERE.
    Fields with + or - are used in ORDER BY.
    For example, the code: +Date,+Sum,@Company,Item
    generates the SQL code:
    SELECT Data, Sum, Company, Item FROM <table> WHERE Company = @Company ORDER BY Date, Sum
    This feature simplifies creating drill-down queries for business users.
  • New column event handlers: ConvertFormulas and DoNotConvertFormulas
    For columns with ConvertFormulas, the add-in tries to convert text formulas from a database to Excel formulas.
    This allows having values and configured formulas in the same column.
    For columns with DoNotConvertFormulas, the add-in disables auto-detecting formulas and do not convert them.
  • New methods for using with VBA. Here are groups of new methods:
    - ribbon control;
    - executing queries to databases, web data sources and text files;
    - working with connection strings;
    - protecting usernames and passwords;
    - working with cursors and form fields;
    - working with table views;
    - add-in options.
  • You may choose stored procedure parameters to place to the ribbon.
    It is useful for procedures with more than six parameters.
  • You may specify WHERE field values without placing the fields to the ribbon.
  • The add-in may automatically remove the named cells with error ranges.
    You may disable this option if use macros that fix such errors.

Improvements:

  • Values of the fields that have Formula or FormulaValue handlers are used in the generated SQL even the fields are not selected.
    The best case is using the =UserName() and =NOW() formulas to update the LastUserName and LastModified columns.
    Now such fields have the correct values even the fields are not selected in Excel.
  • Event handlers may use new context parameters, CellDateValue and CellNumberValue.
    The parameters contain datetime and number values if possible or NULL.
  • Form fields can be created on any worksheet. The form fields on other sheets must have a workbook scope.
    Such fields update the underlying table. So, you may use the fields to create edit forms easily.
  • Improved detection of formula columns.
    For such columns, the add-in converts text formulas from a database to Excel formulas.
    You may change the automatic detection using the ConvertFormulas and DoNotConvertFormulas handlers.
  • Improved performance of scrolling on tables with form fields and cursors.
  • Improved Pivot Data Connection Wizard.
    The wizard allows creating multiple pivot tables on a sheet connected to a single data source.
  • Improved messages of the Register Product wizard.

Bug Fixes:

  • SQL execution errors of Change handlers that contain DECLARE statements.
  • Loss of parameter values in the Parameter Editor form.
  • Generating UPDATE commands in the merge mode for a table without fields for UPDATE.
  • Loss of sort orders after refreshing tables with ValidationList handlers.
  • Loss of ribbon fields after connection string change using VBA.
  • Loss of date validations that starts at 1/1/1900.
  • Absent English in the Data Language list if the English keyboard layout is not installed on Windows.
  • Detecting tables with INSTEAD OF triggers like as TRIGGERED VIEWs.
  • Detecting CSV data with one column as text.
  • Detecting JSON data with two-dimensional arrays as text.

Version 7.1.1, February 9, 2017

Bug Fixes:

  • Fixed issues with Data Merge Wizard.
  • Fixed issues with cursor fields.

Version 7.1, February 3, 2017

New Features:

  • Ribbon parameters may get values from Excel ranges.
    Set the RANGE type in the SELECT_TYPE field and a range name or address in the SELECT_CODE field.
  • Ribbon parameters may get values specified in the SELECT_CODE field directly.
    Set the VALUES type in the SELECT_TYPE field.
  • You may specify field names used to select ribbon parameter values from tables and views in the SELECT_CODE column.
    This feature allows getting values without SQL code use.
  • ValidationList and SelectionList may get values from Excel ranges.
    Set the RANGE type in the HANDLER_TYPE field and a range name or address in the HANDLER_CODE field.
  • ValidationList and SelectionList may get values specified in the HANDLER_CODE field directly.
    Set the VALUES type in the HANDLER_TYPE field.
  • You may specify field names used to select ValidationList and SelectionList values from tables and views in the HANDLER_CODE column.
    This feature allows getting values without SQL code use.
  • The Wizards, Workbook Templates and Examples menu and SaveToDB SDK include Developer Guide 7.1.
    The new guide shows how to create Excel application using new SaveToDB 7.1 features, without SQL or VBA use. Try it.

Improvements:

  • The add-in uses ribbon parameter and named cell values for new row cells protected by DoNotChange handlers.
    Such cells had NULL values before.
  • The Copy and Insert Rows button copies values protected by DoNotChange handlers.
  • You may disable DoNotChange handlers in macros. Set Application.DisplayAlerts = True.

Bug Fixes:

  • Fixed inserting rows instead of updating in SQL Server in some cases. The bug was added in SaveToDB 7.0.
  • Fixed error messages on selecting the entire worksheet with the active List Editor.
  • Fixed bad values calculated by the =UserName() and =DomainUserName() functions.

Version 7.0.3, January 25, 2017

Bug Fixes:

  • Fixed issues with creating SQLite databases.
  • Fixed issues with List Editor.
  • Fixed issues with saving table formats to SQL Server.

Version 7.0.2, January 20, 2017

Bug Fixes:

  • Fixed issues with PowerQuery compatibility.
  • Fixed issues with Query Lists.

Version 7.0.1, January 17, 2017

Bug Fixes:

  • Fixed issues with MySQL ODBC drivers.

Version 7.0, January 17, 2017

Licensing Changes

  • The free SaveToDB Express edition is available again.
    However, the new Express edition has other limits than previous versions. See Edition Comparison.
  • Starting SaveToDB 7, major upgrades are not free.
    You may purchase and renew Upgrade Warranty of free upgrading to the latest major versions.
  • As a special case, customers, who bought SaveToDB 6.x versions, may upgrade to SaveToDB 7 for free, using the same product codes.
    Customers, who bought SaveToDB 1.x-5.x versions, may purchase an upgrade license.
  • The SaveToDB add-in is available as a subscription.
    During the subscription period, you may upgrade to the latest versions for free.
  • The SaveToDB Personal edition allows saving OData data.
    So it has the same features as the SaveToDB Enterprise edition.

Upgrade Notes

  • Previous versions are converted to a new trial version with a 30-day period.
  • Customers, who bought SaveToDB 6.x versions, may register SaveToDB 7 for free, using the SaveToDB 6.x product codes.
  • Customers, who bought SaveToDB 1.x-5.x versions, may purchase an upgrade license and register SaveToDB 7, or uninstall SaveToDB 7.0 and install the previous version.
    In the last case, you may continue to use the previous registered version without additional actions.
  • Customers, who use free SaveToDB Express 1.x-5.x versions, may purchase a full license or subscription and register SaveToDB 7, or uninstall SaveToDB 7.0 and install the previous version.
    In the last case, you may continue to use the previous registered version without additional actions.
  • SaveToDB 7.0 supports all previous versions of server-side configurations.
    So, you do not need to change your databases before the upgrade.
  • You may upgrade previous versions of SaveToDB Framework to the newest SaveToDB Framework 7.0.
    SaveToDB SDK contains upgrade SQL codes for all database platforms.

Download Package Changes

  • The SaveToDB 7 setup package does not include gConnectionManager, gsqlcmd, and gwebcmd.
    You may install these products using separate setup packages.

New features:

  • SaveToDB supports working with SQLite databases.
    SQLite is the best database platform for creating personal Microsoft Excel applications using the SaveToDB add-in.
    SQLite database files can be located in workbook folders, and data can be loaded to multiple workbooks and worksheets in different views.
    The free SaveToDB Express edition has no limits and delays for both SQLite and Microsoft SQL Server Compact databases.
    However, SQLite supports views, and Microsoft Excel supports connecting to SQLite via ODBC drivers.
  • The SaveToDB add-in may read server-side configurations from tables like from views.
    This feature allows creating database applications in a single schema, with data and configuration tables, without using SaveToDB Framework.
    You may create required configuration tables and views using SaveToDB Framework source codes just replacing schemas.

Improvements:

  • The latest SaveToDB Framework 6.9 and 6.10 are renamed to SaveToDB Framework 7.0.
    SaveToDB Framework 7.0 includes updated batch files.
    SaveToDB Framework Installer allows installing the latest SaveToDB Framework 7.0 only.
  • SaveToDB SDK 7.0 includes new examples for SQLite and updated examples for other database platforms.
  • The updated SaveToDB installer creates menus in Windows 8 and Windows 10 styles.
  • Significantly improved performance of executing MySQL commands.
  • The SQL Debug mode has been removed.

Install and Uninstall

Installing SaveToDB

To install the SaveToDB add-in:

  • Download and unzip SaveToDB setup package to a local folder.
  • Close Microsoft Excel.
  • Run setup.exe.

SaveToDB requires the following pre-installed Microsoft components:

  • NET Framework 4 Client Profile or Microsoft .NET Framework 4.
  • Microsoft Visual Studio 2010 Tools for Office Runtime (VSTOR 2010).

If these components are not installed, you will be asked to download and install them from the Microsoft website.
It may require downloading additionally about 45MB.

See also Corporate Deployment.

Updating SaveToDB

To update the SaveToDB add-in, just install a new version.

Alternatively, you may uninstall SaveToDB first and then make a clean install.

Upgrading from SaveToDB 2.x-5.x

Previous major versions are converted to a new trial version with a 30-day period.
After that period, you may purchase and register a new major SaveToDB version, or uninstall it and install the previous version.
In the last case, if the previous major version was registered, you may continue to use it without additional actions.

Starting SaveToDB 6.0, the SaveToDB Suite setup package is not available.

If you have installed SaveToDB Suite of the previous version, please, uninstall it before installing version SaveToDB 6.0 or higher.

You may install the RealTimeToDB and RealTimeToExcel products using separate installers. 

Starting SaveToDB 7.0, the SaveToDB setup package does not include gConnectionManager, gsqlcmd, and gwebcmd products.
You may install the products using separate setup packages.

Uninstalling SaveToDB

To uninstall the SaveToDB add-in:

  • Close Microsoft Excel.
  • Open Control Panel.
  • Open Programs and Features.
  • Select SaveToDB and click the Uninstall button.

Corporate Deployment

To install SaveToDB, use a standalone installer unzipped to a shared network folder.

The install package is signed by VeriSign digital ID and does not require administrator privileges to setup.

So a user can install SaveToDB himself if the required Microsoft components are pre-installed.

SaveToDB requires the following pre-installed Microsoft components:

  • NET Framework 4 Client Profile or Microsoft .NET Framework 4.
  • Microsoft Visual Studio 2010 Tools for Office Runtime (VSTOR 2010).

If these components are not installed, the user will be asked to download and install them from the Microsoft website.
It may require downloading additionally about 45MB.

To deploy these components, system administrators can use the following links:

.NET Framework 4 Client Profile

2/21/2011, 41.0MB

600MB for x86 and 1.5GB for x64 of free disk space is required, but not used during installation.

Microsoft .NET Framework 4 Client Profile (Standalone Installer)
http://www.microsoft.com/en-us/download/details.aspx?id=24872

Microsoft .NET Framework 4 Client Profile (Web Installer)
http://www.microsoft.com/en-us/download/details.aspx?id=17113

.NET Framework 4 Full

2/21/2011, 48.1MB

In most cases, the full framework is the best choice.

850MB for x86 and 2.0GB for x64 of free disk space is required, but not used during installation.

Microsoft .NET Framework 4 (Standalone Installer)
http://www.microsoft.com/en-us/download/details.aspx?id=17718

Microsoft .NET Framework 4 (Web Installer)
http://www.microsoft.com/en-us/download/details.aspx?id=17851

Microsoft Visual Studio 2010 Tools for Office Runtime

7/15/2014, 38.3 MB

Visual Studio 2010 Tools for Office Runtime
http://www.microsoft.com/en-us/download/details.aspx?id=48217

System Requirements

Supported Versions of Microsoft Excel:

  • Microsoft Excel 2007, 2010, 2013, 2016

Supported Architectures:

  • x86
  • x64

Supported Operating Systems:

  • Windows XP SP3, Vista SP1, 7, 8, 8.1, 10
  • Windows Server 2003 SP3, 2008, 2008 R2, 2012, 2012 R2, 2016

Supported Versions of Microsoft SQL Server:

  • Microsoft SQL Server 2005, 2008, 2008 R2
  • Microsoft SQL Server 2012, 2014, 2016 including Express LocalDB
  • Microsoft Azure SQL Database

Supported Versions of Microsoft SQL Server Compact:

  • Microsoft SQL Server Compact 3.5, 4.0

Supported Versions of Oracle Database:

  • Oracle Database 10g Release 1, Release 2
  • Oracle Database 11g Release 1, Release 2
  • Oracle Database 12c Release 1

Supported Versions of IBM DB2:

  • IBM DB2 9.5, 9.7, 9.8, 10.1, 10.5, 11.1

IBM DB2 .NET Provider, IBM DB2 OLE DB Provider or IBM DB2 ODBC driver installed is required.

Supported Versions of MySQL:

  • MySQL 5.0, 5.1, 5.2, 5.5, 5.6, 5.7

Supported Versions of SkySQL MariaDB:

  • MariaDB 5.1, 5.2, 5.3, 5.5, 10.0, 10.1, 10.2

Supported Versions of NuoDB:

  • NuoDB 2.0.4, 2.1, 2.2, 2.3, 2.4, 2.5, 2.6

Supported Versions of PostgreSQL:

  • PostgreSQL 8.0, 8.1, 8.2, 8.3, 8.4
  • PostgreSQL 9.0, 9.1, 9.2, 9.3, 9.4

Supported Versions of SQLite:

  • SQLite 2, 3

Supported Versions of SaveToDB Framework:

  • SaveToDB Framework 2.0, 3.0, 4.0, 4.7, 5.0, 6.2, 6.7, 6.8, 6.9, 6.10, 7.0.

Trial Version Limitations

You can use SaveToDB without any limit during a 30-day trial period.

You have to activate the trial.

When the trial period has expired, the SaveToDB add-in stops working, and you have the following options:

  1. To purchase a license and register the SaveToDB Personal or Enterprise edition.
  2. To purchase a subscription and register the SaveToDB Personal or Enterprise edition.
  3. To stop the use and remove SaveToDB from a computer.

See also

End-User License Agreement

This End-User License Agreement (EULA) is a legal agreement between you (either an individual or a single entity) and Gartle Technology Corporation for any SaveToDB software, use examples and documentation (Software) that accompany this EULA.

YOU AGREE TO BE BOUND BY THE TERMS OF THIS EULA BY INSTALLING, COPYING, OR OTHERWISE USING THE SOFTWARE.

IF YOU DO NOT AGREE, DO NOT INSTALL, COPY, OR USE THE SOFTWARE.

Your licensing of Software is in accordance with the terms of the EULA in effect at the time of such licensing. By licensing Software, you accept and agree to the EULA in effect at such time.

  1. GRANT OF LICENSE: Gartle Technology Corporation grants you the following rights provided that you comply with all terms and conditions of this EULA:
    1. Trial Period: You may install, use, access, display and run the Software for purposes of evaluation of the Software for a period of thirty (30) days from the date of installation of the Software to determine if the Software meets your needs. Upon completion of your evaluation or at the end of the 30-day trial period, whichever occurs first, you must do one of the following:
      1) purchase a license of SaveToDB Personal, SaveToDB Standard, or SaveToDB Enterprise to continue use of Software;
      2) purchase a subscription to SaveToDB Personal, SaveToDB Standard, or SaveToDB Enterprise to continue use of Software;
      or 3) discontinue use of the Software and uninstall the Software.
    2. Installation and Use: You may install, use, access, display and run one (1) copy of the Software per license, on a non-exclusive basis and without right of sublicense or concurrent use, on a single computer or machine, such as a workstation.
    3. Software Transfer: You may transfer the Software to a different internal workstation or user so long as you have purchased a License for each such workstation or user. You may not, however, transfer the Software to a Third Party.
    4. Use of Examples: You may install, access, modify and use Software examples, including Microsoft Excel workbooks, databases, SQL codes, and batch files, for your private or company-internal purposes.
  2. LIMITATIONS: You may not use, copy, modify, display, rent, lease, loan, transfer, distribute, download, merge, or make any translation or derivative work of the Software, except as expressly provided herein. You may not reverse engineer, decompile, or disassemble the Software, except and only to the extent that such activity is expressly permitted by applicable law notwithstanding this limitation.
  3. INTELLECTUAL PROPERTY RIGHTS AND CONFIDENTIALITY: The Software, including methods, processes and/or techniques utilized therein, is owned by, proprietary to and valuable trade secrets of Gartle Technology Corporation and is protected by Russian Federation copyright law and international treaties. You agree to take no actions that impair or infringe Gartle Technology Corporation's intellectual property rights in the Software. You agree not to remove, efface or obscure any copyright notices, other proprietary markings or confidentiality legends placed upon or contained within the Software.
  4. DISCLAIMER OF WARRANTIES: Gartle Technology Corporation disclaims all warranties concerning the Software and Services (if any), express, implied, or statutory, including without limitation, any warranties, duties or conditions of merchantability or fitness for a particular purpose, warranties of reliability or availability, of accuracy or completeness of responses, of results, of workmanlike effort, of lack of viruses, and of lack of negligence, all with regard to the Software, and the provision of or failure to provide support or other services, information, software, and related content through the Software or otherwise arising out of the use of the Software. Gartle Technology Corporation does not warrant that the Software will operate in combination with other software products selected by you, or that the Software will operate uninterrupted or error-free. Additionally, Gartle Technology Corporation and its suppliers provide the Software and Services AS IS AND WITH ALL FAULTS. THERE IS NO WARRANTY OR CONDITION OF TITLE, QUIET ENJOYMENT, QUIET POSSESSION, CORRESPONDENCE TO DESCRIPTION, OR NONINFRINGEMENT WITH REGARD TO THE SOFTWARE.
  5. NO LIABILITY: TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, IN NO EVENT SHALL GARTLE TECHNOLOGY CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY SPECIAL, INCIDENTAL, PUNITIVE, INDIRECT, OR CONSEQUENTIAL DAMAGES WHATSOEVER (INCLUDING, BUT NOT LIMITED TO, DAMAGES FOR LOSS OF PROFITS OR CONFIDENTIAL OR OTHER INFORMATION, FOR LOSS OF DATA, FOR BUSINESS INTERRUPTION, FOR PERSONAL INJURY, FOR LOSS OF PRIVACY, FOR FAILURE TO MEET ANY DUTY INCLUDING OF GOOD FAITH OR OF REASONABLE CARE, FOR NEGLIGENCE, AND FOR ANY OTHER PECUNIARY OR OTHER LOSS WHATSOEVER) ARISING OUT OF OR IN ANY WAY RELATED TO THE USE OF OR INABILITY TO USE THE SOFTWARE, THE PROVISION OF OR FAILURE TO PROVIDE SUPPORT OR OTHER SERVICES, INFORMATION, SOFTWARE, AND RELATED CONTENT THROUGH THE SOFTWARE OR OTHERWISE ARISING OUT OF THE USE OF THE SOFTWARE, OR OTHERWISE UNDER OR IN CONNECTION WITH ANY PROVISION OF THIS EULA, EVEN IN THE EVENT OF THE FAULT, TORT (INCLUDING NEGLIGENCE), MISREPRESENTATION, STRICT LIABILITY, BREACH OF CONTRACT OF GARTLE TECHNOLOGY CORPORATION OR ANY SUPPLIER, AND EVEN IF GARTLE TECHNOLOGY CORPORATION OR ANY SUPPLIER HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
  6. LIMITATION ON REMEDIES: Within the first thirty (30) days after your receipt of the Software, should you encounter and report to Gartle Technology Corporation within such time period a reproducible error that causes the Software not to perform in all material respects as set forth in the Software documentation, then Gartle Technology Corporation will, at its sole discretion, either: a) resolve the error or malfunction, and modify or replace the Software (if deemed necessary by Gartle Technology Corporation); or b) allow you to terminate this EULA with respect to the non-conforming Software and, upon your return of the Software to Gartle Technology Corporation, Gartle Technology Corporation shall provide you with the lesser of a) the actual damages incurred by you; or b) the amount you paid for the non-conforming Software. The remedies described in this section shall be your sole and exclusive remedies under this EULA.
  7. GENERAL PROVISIONS
    1. Reservation of Rights and Ownership: Gartle Technology Corporation reserves all rights not expressly granted to you in this EULA. The Software is licensed, not sold.
    2. Consent to Use of Data: You agree that Gartle Technology Corporation and its affiliates may collect and use technical information gathered as part of the Software support services provided to you, if any, related to the Software. Gartle Technology Corporation may use this information solely to improve Gartle Technology Corporation products or to provide customized services or technologies to you and will not disclose this information in a form that personally identifies you.
    3. Links to Third Party Sites: We may link to third-party sites through the use of the Software. The third-party sites are not under the control of Gartle Technology Corporation, and Gartle Technology Corporation is not responsible for the contents of any third-party sites, any links contained in third-party sites, or any changes or updates to third-party sites. Gartle Technology Corporation is not responsible for webcasting or any other form of transmission received from any third-party sites. Gartle Technology Corporation is providing these links to third-party sites to you only as a convenience, and the inclusion of any link does not imply an endorsement by Gartle Technology Corporation of the third-party site.
    4. Additional Software/Services: This EULA applies to updates, supplements, add-on components, or Internet-based services components, of the Software that Gartle Technology Corporation may provide to you or make available to you after the date you obtain your initial copy of the Software, unless Gartle Technology Corporation provides other terms along with the update, supplement, add-on component, or Internet-based services component. Gartle Technology Corporation reserves the right to discontinue any Internet-based services provided to you or made available to you through the use of the Software.
    5. Upgrades: To use Software identified as an upgrade, you must first be licensed for the software identified by Gartle Technology Corporation as eligible for the upgrade. After upgrading, you may no longer use the software that formed the basis for your upgrade eligibility.
    6. Applicable Law: This EULA is governed by the laws of the Russian Federation. Any legal action or proceeding relating to this EULA shall be instituted in a court of arbitration in the Moscow City, Russian Federation. Gartle Technology Corporation and you agree to submit to the jurisdiction of, and agree that venue is proper in, these courts in any such action or proceeding. The prevailing party in any action to enforce this EULA will be entitled to recover its attorney fees and costs in connection with such action.
    7. Waiver: The failure of either party to enforce any of the terms of this EULA shall not be construed as a waiver of future enforcement of that or any other term.
    8. Entire Agreement and Severability: This EULA (including any addendum or amendment to this EULA which is included with the Software) is the entire agreement between you and Gartle Technology Corporation relating to the Software and the support services (if any) and it supersedes all prior or contemporaneous oral or written communications, proposals and representations with respect to the Software or any other subject matter covered by this EULA. To the extent the terms of any Gartle Technology Corporation policies or programs for support services conflict with the terms of this EULA, the terms of this EULA shall control. If any provision of this EULA is held to be void, invalid, unenforceable or illegal, the other provisions shall continue in full force and effect.
    9. Termination: Without prejudice to any other rights, Gartle Technology Corporation may terminate this EULA if you fail to comply with the terms and conditions of this EULA. In such event, you must destroy all copies of the Software and all of its component parts and you will not be entitled to any refund of monies.

SaveToDB SDK

The SaveToDB add-in allows end users to work with databases and web data from-the-box.

However, the real power of the add-in is uncovered when the user interface is customized by database developers.

In this case, Microsoft Excel can be used as a feature-rich desktop client of database applications.

SaveToDB SDK includes SaveToDB Framework and examples for local deployment.

SaveToDB Framework allows quickly to add ready infrastructure in a database for the server-side configuring.

SaveToDB examples allow learning and testing applications in your environment.

SaveToDB Framework is available for all SaveToDB supported database platforms:

Frequently Asked Questions

Is it possible to use the localized names for table columns, output columns of views and stored procedures?
Yes. Database servers support the localized names.
However, if you want to save data changes back to a database, then the names should conform to rules for stored procedure parameter names.
For example, space and non-alphanumeric symbols are not supported in parameter names.
At the same time, we recommend to use English names and configure the data translation.
Can I use spaces in column names of tables and views?
Yes, you can. However, these fields cannot be used in procedures parameters for saving data and handling events as they do not conform to requirements for procedure parameter names.
We advise to use English names of fields without spaces and use the data translation within Microsoft Excel.
I cannot save Excel table changes to a database. What to do?
See Required conditions to save changes.
I receive a message of operation timeout when saving changes of a big data table. How can I increase the operation timeout?
Change the Command Timeout using the Options dialog box.
I receive a message of operation timeout when publishing data. How can I increase the operation timeout?
Change the Command Timeout using the Options dialog box.
Why does the Microsoft Excel Refresh menu not work for MySQL?
The SaveToDB add-in uses the .NET provider for working with MySQL by default.
It allows you to work with MySQL without installing additional components. You may load and save data using the SaveToDB add-in.
For the full support of MySQL in Microsoft Excel, you have to install the ODBC driver from MySQL website and use this driver when connecting to MySQL database.
Why does the Microsoft Excel Refresh menu not work for Microsoft SQL Server Compact?
Microsoft Excel does not support working with Microsoft SQL Server Compact.
The SaveToDB add-in uses the .NET provider for working with Microsoft SQL Server Compact without installing additional components.
You may load and save data using the SaveToDB add-in.
Why does the Microsoft Excel Refresh menu not work for web data?
The SaveToDB add-in uses an internal provider with advanced features for working with web data.
Why do web-requests sometimes display wrong data?
The SaveToDB add-in uses smart algorithms for parsing table data from web pages in HTML, XML, and JSON formats.
If there are several tables on the page, then the most suitable one is chosen. Sometimes it can be the table of contents, which contains more "useful" data than the real table with data.
Try to use pages for printing which contain fewer formatting tables.
If a web page is not parsed correctly, you may send us a request. We will try to change the algorithms.
Why are user passwords saved unencrypted?
SaveToDB uses standard Microsoft Excel features for working with databases. Microsoft Excel saves the passwords unencrypted.
You may encrypt the entire workbook or even the disk drive to prevent using your password by other people.
SaveToDB allows using workbook personally at all as other users can connect the data using their credentials.
SaveToDB uses an internal provider for working with web data.
For web data, user's sensitive information is encrypted using Windows encryption features.
Microsoft Excel cannot connect to Oracle. What is the problem?
If connection data is correct and the server is available, see Fixing Oracle Database 10g Connection Error.
Why do I have to reenter the password to have access to web data?
The possible reasons are:
the password is changed,
or the workbook is opened under another user account,
or the login credentials have expired.
Why does the Query List show native, not translated, names for all database objects?
The translation must be configured in a database, and the appropriate data language should be selected in the Options dialog box.
Why does the Query List show native, not translated, names for some database objects?
If several objects have the same name after translation, then the first name is displayed translated, and the others are displayed with the native database names.
All translated object names should be unique.
Can I change the name of the SaveToDB tab to another?
Yes, you can. See the SaveToDB Tab.
Why is the Publish Wizard disabled?
The wizard works with Excel tables early named "Lists". Any table cell must be selected.
See Publish Wizard for a complete description.
In short, select the desired table range and click Excel "Insert, Table" to insert an Excel table.
SaveToDB tab has disappeared. What should I do?
Select File, Options and activate the Add-Ins tab.
If the SaveToDB add-in is in the Inactive Application Add-Ins group, then select COM Add-ins in the Manage combo box and the Go... button.
Then select the SaveToDB and click OK.
If the SaveToDB add-in is in the Disabled Application Add-Ins group, then select Disabled Items in the Manage combo box and the Go... button.
Then select the SaveToDB and click the Enable button.
I cannot install the SaveToDB add-in. What to do?
The most probable reason is that you try to install the add-in from the path containing some national specific characters.
Try to create a folder named in English and to install it from this folder.
Why are Table Views buttons disabled?
The add-in works with Excel tables early called as Lists.
Possible reason is that your sheet does not contain any table.
To insert an Excel table, select a table region and execute the Excel Insert, Table command.

Product Registration

You can use SaveToDB during a 30-day trial period for free.

During this period, you can try all the features of the SaveToDB Enterprise edition.

When the trial period has expired, the SaveToDB add-in stops working, and you have the following options:

  1. To purchase a license and register the SaveToDB Personal or Enterprise edition.
  2. To purchase a subscription and register the SaveToDB Personal or Enterprise edition.
  3. To stop the use and remove SaveToDB from a computer.

To start the registration process, use the Help, Register Product menu item.

The registration process contains the following steps:

  1. Choosing the SaveToDB edition;
  2. Filling Licensee data;
  3. Activating the product.

Selecting Edition

In the first step, select an edition.

If you install the SaveToDB add-in for the first time, activate the trial version.

To register the SaveToDB Personal or Enterprise edition, a product code is required.

This product code is sent by email after SaveToDB license purchase.

SaveToDB Registration - Select the edition

Licensee Data

In this step, select the activation method, and fill in the form.

SaveToDB Registration - Fill personal data

The Next button is enabled when you check the required field about the personal data use.

Online Activation

After clicking the Next button in the previous step, the SaveToDB add-in connects to the registration server.

If the connection is successful, the final step screen is shown.

SaveToDB Registration - The final step

If any error occurred during connection, you might try to register the product later or try to register the product by email.

Activation by Email

If you choose the Activate by email option, the following screen is displayed:

SaveToDB Registration - Check and start the registration email

Click the Create Email Message button to create an email.

If starting the email program has failed, please create the registration email manually using the shown registration data.
Just copy and paste the To, Subject, and the Message fields.

The registration server sends the reply in a couple of seconds.

Please copy the activation code from the received registration email and paste it into the Activation code field.

SaveToDB Registration - Paste the activation code

The Next button is enabled when the activation code is valid.

Click Next to finish the activation.

SaveToDB Registration - The final step
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.OK