Download URL | Author URL | Software URL | Buy Now ($149.95)
SaveToDB Excel Add-In allows loading data from the web and databases into Excel, and saving data from Excel to databases.
For example, you may load and save stock and option data, financial reports from Yahoo! Finance and from Google Finance.
The add-in allows changing web and database query parameters using the ribbon.
For example, you may load data for AAPL, add formulas and formatting, and then change the symbol to GOOG, YHOO, etc.
The add-in has a lot of features for using Microsoft Excel as a client for databases and web.
The features can be additionally customized using SQL codes or VBA macros.
For example, you may add drill-down queries, selection change handlers, etc.
The download package includes a lot of examples with source codes (Cash Flow, Budget, Financial Reports, Stock Analysis, etc.).
Supported web formats: HTML, XML, JSON, CSV, and plain text.
Supported databases: SQL Server, SQL CE, Oracle Database, IBM DB2, MySQL, MariaDB, NuoDB, PostgreSQL.
Vertically merge one Oracle table into another. The tables can be located in the same Oracle database or two different databases.
gsqlcmd is a command line utility that allows: - executing SQL scripts; - exporting database data to text and CSV; - exporting database data to HTML; - configuring CSV import; - g ...
gsqlcmd is a command line utility that allows: - executing SQL scripts; - exporting database data to text and CSV; - exporting database data to HTML; - configuring CSV import; - g ...
SaveToDB Excel Add-In allows loading data from the web and databases into Excel, and saving data from Excel to databases. For example, you may load and save stock and option data, ...
SaveToDB Excel Add-In allows loading data from the web and databases into Excel, and saving data from Excel to databases. For example, you may load and save stock and option data, ...