SaveToDB
Version 4.11, December 17, 2014
Content
Important Notes
Remove SaveToDB 4.1 or below before installing SaveToDB.
SaveToDB can be installed for all users. Administrator privileges are required.
The installation folder is being added to the PATH environment variable.
Logoff and logon once before the first use of the gsqlcmd or gwebcmd command line utility.
It is required to reload the PATH environment variable.
Open CHM help files only from local drives, not from network paths.
Opening the CHM files from the network paths is not supported by Windows.
If the CHM does not show contents, open the file properties and click the "Unblock" button on the General tab.
Quick Start
- Close Microsoft Excel.
- Install SaveToDB.
- Open Microsoft Excel. You should see the SaveToDB tab.
- Close Microsoft Excel. Logoff and logon.
- Try interesting examples for Web, SQL Server, or SQL Server Compact.
Just open workbooks and try interesting actions.
Subscribe for Tips and Tricks
You may become an expert in advanced Excel techniques.
Just subscribe for SaveToDB Tips and Tricks sending an empty email to savetodb_tips_and_tricks@getresponse.net.
You will receive series of emails that helps you to learn and try useful tips and tricks.
You may cancel your subscription any time.
Installing and Uninstalling
Installing SaveToDB
To install the SaveToDB, close Microsoft Excel, if opened, and run setup.exe.
Updating SaveToDB
Remove the previous SaveToDB installation before installing SaveToDB
if the previous version has number 4.1 or below.
If the SaveToDB 4.2 or higher installed, just install the new version.
Uninstalling SaveToDB
To uninstall the SaveToDB:
- Close Microsoft Excel.
- Open Control Panel.
- Open Program and Features.
- Select SaveToDB and click the Uninstall button.
Package Content
- setup.exe
- The installation file.
Run this file to install products and required prerequisite components.
- SaveToDB.msi
- The MSI installation package.
Use this file to install products if the required prerequisite components are already installed on the computer.
- readme.htm
- This Readme file.
- savetodb-resources-en.htm
- The file contains useful SaveToDB online resources.
Use this file as a start point.
- Applications
- The folder contains ready-to-use applications.
- Examples for SQL Server
- The folder contains examples for Microsoft SQL Server.
You may use examples immediately after SaveToDB install as the example databases are deployed in Microsoft SQL Azure Database. You may find the
example source code in the SaveToDB SDK.
- Examples for SQL Server Compact
- The folder contains examples for Microsoft SQL Server Compact.
You may use examples immediately after SaveToDB install.
- Examples for Table Views
- The folder contains examples for working with the table views.
- Examples for Web
- The folder contains examples for working with the web.
- Licenses
- The folder contains licenses of installed products and components.
Applications
- Application - Monthly Cash Flow
- The example application allows getting money transactions in a one place and building cash flow statements.
The application uses a local Microsoft SQL Server Compact database, so you may use it right after installation.
- Application - Monthly Cash Flow Adv + VBA
- The example application allows getting money transactions in a one place and building cash flow statements.
In addition, the example shows how to work with normalized tables and to use SaveToDB as a VBA library.
The application uses a Microsoft SQL Server Compact database, so you may use it right after installation.
- Social Contacts
- The example application allows getting social contacts in a local Microsoft SQL Server Compact database and into Microsoft Excel.
You may import social contacts from LinkedIn, Facebook, Google, Yahoo!, Windows Live, Outlook, etc.
The application allows removing duplicate contacts and enriching contact data from multiple data sources.
- Social Contacts for SQL Server
- The example application allows getting social contacts in a Microsoft SQL Server database and into Microsoft Excel.
You may import social contacts from LinkedIn, Facebook, Google, Yahoo!, Windows Live, Outlook, etc.
The application allows removing duplicate contacts and enriching contact data from multiple data sources.
- Application - Web Finance
- The example application allows getting end of a day stock data from Google Finance or Yahoo! Finance and saving loaded data into a local Microsoft
SQL Server Compact database.
Examples for Microsoft SQL Server
- Azure Catalog
- This powerful example shows most of the add-in features including working with hierarchy catalogs.
- Azure Calendar
- The example shows working with a calendar using Excel event handlers.
- Azure Monthly Cash Flow
- The example is a simple monthly cash flow application.
- Azure Monthly Cash Flow + VBA
- The example is a simple monthly cash flow application that shows how to use the SaveToDB add-in as a VBA library.
- Azure Budget
- The example is a simple application for cash-flow planning and monitoring.
- Azure Stocks
- The example is a simple application for stock analysis.
- Azure Tasks
- The example is a simple To-do application.
- Database Management
- This application allows auditing and changing user roles and permissions using Microsoft Excel.
- Extended Properties Editor
- This example shows how to create, modify, and delete extended properties using Microsoft Excel.
Examples for SQL Server Compact
- Example - DDE Interactive Brokers
- The example shows how to use and configure DDE formulas without using macros.
The example works with Trader Workstation (TWS), a powerful trading platform from Interactive Brokers.
- Example - DDE Thinkorswim
- The example shows how to use and configure DDE formulas without using macros.
The example works with Thinkorswim Desktop, a powerful trading platform from Thinkorswim, Division of TD Ameritrade.
- Example - Loading Text
- The example shows how to load data from text files in the CSV, XML, and HTML formats into a database.
- Example - Saving Changes to Database
- The example shows how to save data changes back to a database using different techniques.
- Example - Using Event Handlers
- The example shows how to use database objects and codes for Excel event handling.
This is a simple and powerful feature. It allows saving changes on the cell change event, implementing master-detail interfaces, drill-down queries, etc.
- Example - Using Macros
- The example shows how to use macros with the SaveToDB add-in.
The SaveToDB add-in brings additional benefits for traditional Excel applications built using macros.
Examples for Web
- Example - Web Finance
- The example shows how to get data from financial websites like Yahoo! Finance or Google Finance into Microsoft Excel.
- Example - Social Contacts
- The example shows how to get social contacts from different sources in Microsoft Excel.
You may import social contacts from LinkedIn, Facebook, Google, Yahoo!, Windows Live, Outlook, etc.
- Example - Financials from Google Finance
- The example shows how to load financial statements from Google Finance.
- Example - Financials from Yahoo! Finance
- The example shows how to load financial statements from Yahoo! Finance.
Copyright © 2010-2014 Gartle Technology Corporation