SaveToDB Add-In for Microsoft Excel

Creating feature-rich databases applications

SQL Server, SQL Data Warehouse, Oracle, MySQL, PostgreSQL

Connect to Tables and Views

SaveToDB allows connecting to database tables & views.

You may select SELECT & WHERE fields and change filter values using the ribbon or named cells.

Use Data Connection Wizard for the first connection.
Then you may select the query object using Query List.

You may have fewer worksheets and refresh query lists to get new tables and views from a database.

Connect to Database Tables and Views

Connect to Stored Procedures

SaveToDB allows connecting to stored procedures.

SaveToDB places stored procedure parameters on the ribbon, and you may change parameter values.

Developers may specify value lists for parameters.
The value lists may contain ID and value pairs.

You may use Query List to change the active procedure.

Connect to Stored Procedures

Load Data from the Web

The SaveToDB add-in allows connecting to web pages and web services. SaveToDB converts HTML, XML, JSON, XML, plain text and CSV data into Excel tables.

So you may load financial reports, stock and option quotes, fundamental data, social contacts, etc. in Excel.

Use Data Connection Wizard for the first connection.
Then change query parameters using the ribbon.
SaveToDB preserves formulas and formatting.

Load Data from Web

Create Different Table Views

You may save multiple views of underlying tables.

Apply auto filters, sort data, hide columns, add subtotals, and save the view with a clear name.

Then activate the view when you need from the view list.

This feature works for all Excel tables.

Create Different Table Views

Distribute Formatted Data

Developers may install SaveToDB Framework in a db.

And you may save Excel formats for database objects in a database, including saved table views.

Your colleagues will load the formatted data.

Use Table Format Wizard to manage formats.

Distribute Excel Table Formats from Databases

Save Changes using Save Button

SaveToDB allows saving data changes to database tables.

Yes, you may use Excel as a database table editor.
Use Search & Replace or formulas, and save the data.

Developers may configure saving changes for data loaded from views and stored procedures.

Developers may specify SQL codes or stored procedures for INSERT, UPDATE and DELETE operations.

Connect to Database Tables and Views

Save Changes on Change Event

Another way to save changes is using SQL codes or stored procedures as cell Change event handlers.

So the database is updated immediately after the change.

To add handlers, install SaveToDB Framework and add configuration records to the EventHandlers table.

Handlers may use values from table columns.

    INSERT dbo.Companies (CompanyName)
        VALUES (@CompanyName)
    UPDATE dbo.Companies
        CompanyName = @CompanyName
        ID = @ID

Publish Data to Databases

SaveToDB allows designing database tables and inserting data from Excel using the Data Publish Wizard.

After publishing your team may edit database table data from multiple workbooks connected to the table.

This is the easiest way to share data with your colleagues without sharing workbooks.

Create Database Tables and Publish Data from Excel

Translate DB Names in Excel

Developers may install SaveToDB Framework in a db.

The ColumnTranslation table may be used to translate column and parameter names to a business language.

The ObjectTranslation table is used to translate database object and event handler names.

SaveToDB performs translating in Excel.

Translate Database Object Names in Excel to Business Language

Run Queries from Actions Menu

Developers may define stored procedures for the SaveToDB Actions menu for every database object.

SaveToDB shows items related to the active Excel table.
The add-in requests parameter values before calls.

Use the object translation feature to show user-friendly names in the menu.

Run Queries from SaveToDB Actions Menu

Run Queries from Context Menu

Developers may add queries to the Excel context menu.

The queries may use values from the active row.

SaveToDB allows using tables, views, stored procedures, HTTP requests, macros, batch files, and CMD commands.

Outputs: a worksheet, popup window, or a browser.

-- SQL context query
SELECT * FROM dbo.Payments
    WHERE CompanyName = @CompanyName
-- HTTP context query
Search {CompanyName} in Google{CompanyName}

Define Excel Formulas in Views

SaveToDB allows defining Excel formulas in database views and stored procedures.

For example, line totals can be calculated in Excel.

You may use different formulas for every row like DDE.

Formula results can be saved back to a database.

    , Name
    , Price
    , Qty
    , '=[@Price]*[@Qty]' AS Total

Use SaveToDB from VBA Macros

The SaveToDB add-in has a lot of features.

And you may use it from VBA as a database or web layer.

Just connect a workbook to the web or a database, implement server-side logic and call add-in methods.

Dim addIn As COMAddIn
Dim addInObj As Object
Set addIn = Application.COMAddIns("SaveToDB")
Set addInObj = addIn.Object
Range("Account").Value = 123
Range("Company").Value = "ABC"

Call VBA Macros from SaveToDB

SaveToDB allows executing VBA macros from the Actions menu and from the Excel context menu.

Macros are shown for related objects only and can use context values.

VBA macros can be placed in separate workbooks.
So you may update the macro workbooks only.

Call VBA Macros from SaveToDB

SaveToDB Framework

SaveToDB Framework contains tables, views, and stored procedures to support advanced SaveToDB features.

You may install it in your database using the Framework Installer wizard and edit configuration tables using Excel.
Use Configuration Workbook Generator for this.

SaveToDB Framework Allows Customizing Excel Applications

Use Excel as Client Platform

Microsoft Excel is the best app for working with tables.
Users know and like it.

The SaveToDB add-in allows implementing most client applications with Excel using Excel & SQL only.

You may create amazing applications, step-by-step,
using database development skills only.

Use Excel as Client Platform

SaveToDB Editions

Loading data from database tables, views, and stored procedures
Loading data from the web (HTML, CSV, XML, JSON)
Loading data from Excel, CSV, and DBF using ODBC and OLEDB
Saving data from any data source to a server databasex
Saving data from any data source to SQLite or SQL CE
Saving data to OData web servicesx
All user interface features inluding SaveToDB 9 reporting features
All application development features except cell change event handlers
Cell change event handlersxx
Using as VBA data layer library
SQL Server, Oracle Database, DB2, MySQL, PostgreSQL, NuoDB, Snowflake
SQL Server Compact, SQLite
Commercial use
Price per copy, one timeFree$100$200