SaveToDB Add-In for Microsoft Excel

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.

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.

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.

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.

IF @ID IS NULL
    INSERT dbo.Companies (CompanyName)
        VALUES (@CompanyName)
ELSE
    UPDATE dbo.Companies
    SET
        CompanyName = @CompanyName
    WHERE
        ID = @ID

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.

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
https://www.google.com/search?as_q={CompanyName}

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
addInObj.Save
Range("Account").Value = 123
Range("Company").Value = "ABC"
addInObj.Load

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.