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. 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. The download package includes a lot of examples with source codes (Cash Flow, Budget, Financial Reports, Stock Analysis). Supported web formats: HTML, XML, JSON, CSV, and plain text. Supported databases: SQL Server, SQL CE, Oracle Database, IBM DB2, MySQL, MariaDB, NuoDB.
Requirements:
Microsoft Excel 2007/2010/2013
Comments not found