|
Contents of this Web site:
Main Page
Documentation
F.A.Q.
News
Mailing List
Download
Register
Links
Services
Copyright 2000-2002 by Noromaa Solutions.
All rights reserved.
|
|
Fetch data from SQL databases directly into Microsoft Excel
ExcelSQL is an add-in for Microsoft Excel. It can be used to fetch data from different SQL databases into Microsoft Excel. ExcelSQL works as follows:
- User adds a cell comment into a cell in Excel. The comment contains a header recognized by ExcelSQL:
- User selects the cell with the cell comment, and selects Execute Query from ExcelSQL menu:
- At this point, ExcelSQL reads the text from the cell comment, parses it, and sends it to the ODBC datasource defined in the cell comment (MyDatabase).
- The database sends back results of the query. ExcelSQL processes the results, and writes them onto the Excel sheet starting from the cell where the comment was entered:
ExcelSQL features
The above example discribes the very basic functionality of ExcelSQL. In addition, ExcelSQL has the following advanced features:
- Possibility to use references in cell comments. This way SQL statements can contain variables from other parts of the Excel sheet.
- Possibility to return formulas, cell comments and line breaks from SQL queries.
- Possibility to return columns as rows, and rows as columns (transpose of the data).
 Possibility to group data returned from the database, and to create crosstab-type of output.
- Easy-to-use editor for editing the ExcelSQL queries in cell comments.
See also comparison between ExcelSQL and Microsoft Query.
|
