The Power of SQL in Microsoft Excel
Add-In the power of SQL to Microsoft Excel®
Downloading will allow you to use and evaluate QueryCell
You may find the Getting Started Guide and Articles and Tutorials useful.
The Trial Can be easily removed by uninstalling QueryCell in Control Panel - Add or Remove Programs
This is a fully functional version of QueryCell but it will only allow you to execute a limited number (30) successful queries before expiring
If you decide QueryCell meets your needs, purchase a licence from the Buy Now page and you will be provided with a serial key that can be used to register QueryCell
You may find the Getting Started Guide and Articles and Tutorials useful.
The Trial Can be easily removed by uninstalling QueryCell in Control Panel - Add or Remove Programs
This is a fully functional version of QueryCell but it will only allow you to execute a limited number (30) successful queries before expiring
If you decide QueryCell meets your needs, purchase a licence from the Buy Now page and you will be provided with a serial key that can be used to register QueryCell
QueryCell Supports Excel 2003, 2007 and 2010.
We use Google Analytics to track website usage learn more
logo
We use Google Analytics to track website usage learn more
| Version History | |
| V 1.5 - Released April 2010 | |
| - | Added Visual Query Builder |
| - | Columns/SQL template links in Regions grid changed to buttons |
| - | Removed Mark Rows option |
| V 1.4.4 - Released 2nd March 2010 | |
| - | Added an option that forces String return values to be formatted as Text by Excel (so text values that happen to be all number will not have leading zeros stripped). |
| - | It's now possible to run Insert, Update and Deletes against databases |
| - | QueryCell now adds Named Ranges as data regions |
| - | Added the 'Access DB' checkbox that causes SQL to be formatted for Access |
| - | QueryCell now adds Named Ranges as data regions |
| V 1.4 - Released 2nd March 2010 | |
| - | Added the ability to query ODBC DSN data sources |
| - | QueryCell works with Office 2010 beta |
| - | Improved error reporting. |
| - | Result set is now the last not first worksheet (so existing regions retain their names) |
| - | SQL memo cursor changed from pointer to IBeam, more natural for text. |
| - | Added the ability to save the SQL in the SQL Editor Tabs along with the Excel File via the 'Save SQL' checkbox |
| V 1.3 - Released 27th Aug 2009 | |
| - | Added the Test Data Generator. |
| - | Added the Row Marking, colors rows that match Select criteria. |
| - | Columns whose title ends in _DATE will now default to DATE data type not Varchar. |
| - | Columns whose title ends in _AMT will now default to FLOAT data type not Varchar. |
| - | Behaviour of the Refresh Regions Grid icon changed. Previously it cleared all regions and then scanned all available worksheet in order to re-populat the region grid. Now it will leave all existing regions and merely scan for new regions. In order to replicate the previous behaviour you must first click the Clear Regions Grid icon and then click the Refresh Regions Grid icon. |
| - | Both the left hand side Regions grid column and the right hand side SQL Library / Column Hint Box will now remember their minimized/maximized state. |
| - | The SQL Editor no longer auto-expands on click. This means if you click on a column which has previously never been reached the cursor will revert back to last used column, in the case of an empty line that will be the begining of the line. |
| - | The Column list hint box is now visible whenever the SQL editor is being used, previously it only appeared when a '.' character was typed, signifying TABLENAME.COLNAME. |
| - | Changing a Region/Table name will now automatically reload the Column Hint Box. |
| - | Added support for SUBSTRING SQL function. |
| - | Added list of supported SQL functions to Help file. |
| - | Site License removed and replaced with a 16 user pack. |
| - | Publicity Rights section added to License. |
| V 1.2 - Released 11th June 2009 | |
| - | Added the SQL Generator. |
| - | Added additional Ribbon Icons for Excel 2007. |
| - | Single click of separator splitter bars minimizes regions grid and sql template library. |
| - | Run SQL button moved to above rather than below SQL edit (more vertical room). |
| - | Help changed from button to menu, Help menu contains 'Open Help', 'Open Tutorial' and 'About' options. |
| - | Added 'Save Regions With xls File' checkbox , when checked information about the defined regions will be saved in a worksheet called '--QC--'. These regions will be automatically reloaded into the regions grid when the file is next loaded. |
| - | The refresh regions icon now only applies to non custom regions in the current workbook. |
- Copyright Oak Focus Software / QueryCell 2010 (All Rights Reserved).
- Microsof Excel® is a trademark of Microsoft Corporation.
- The QueryCell Product and its website are not associated with Microsoft Corporation