Try QueryCell - SQL in Excel Add-In

Download The QueryCell Trial Now!

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 14 day limited trial version of QueryCell.
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

V 2.2.0.1 - Released July 2012

Fixed bug wth missing AND in multi key update generator When querying Excel column names with spaces are now wrapped in [ ]

V 2.2 - Released July 2012

The Insert Generator can now output NULL, '' or "" for missing values (Customer Request). The Insert Generator is now limited to producing 20 rows in the trial. After adding a new named range an auto-save is now attempted.

V 2.1 - Released July 2012

The Insert Generator can now generate SQL Updates. ODBC database connections requiring a username and password are now supported.

V 2.0 - Released June 2012

Complete rewrite in C# .net Support for 64 bit office added Test data generator removed Ability to "mark ranges" added. You can color rows in an excel range based on a where clause Queriable tables in Excel are now based on Excel Named Ranges Excel queries are now preformed directly on the workbook, previously data was copied into a database, queried and then returned to Excel

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

No questions asked 30 day from the date of purchase money back guarantee. 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.

Download The QueryCell Trial Now!

Copyright Oak Focus Software / QueryCell 2012, All Rights Reserved