QueryCell is a plugin for Excel to query excel data using SQL

Make BestShareware.net your home page

Add BestShareware.net to your favorites

Homepage

MAC Software | Linux Software | Pocket PC | iPod Software

Software Directories

Internet
Graphics
PC Tools
Applications
Development
DVD & Video
MP3 & Audio
Computer Games
Security & AntiVirus

Applications

Business Finance
Personal Finance
Database Tools
Personal Managers
Business Managers
Inventory Management
Project Managers
Accounting Tools
Home & Education
Unit Conversion
Word Processing

QueryCell

QueryCell is a plugin for Excel that allows you to query excel data using SQL within the Excel application itself.
QueryCell saves time by selecting and joining data within Excel. The SQL Generator comes free with QueryCell and allows you to generate SQL insert statements for excel data in seconds.
Using QueryCell it is very easy to color rows that match your criteria even if your criteria involves joining to other regions of data. Simply check the 'Mark Results' checkbox, Select the color you wish to use and run a SQL statement selecting * from the table you wish to mark and using a WHERE clause to specify your criteria.
Using the QueryCell Test Data Generator you can easily generate thousands of rows of test data in seconds, you can even create test data referencing other Excel data to select foreign key values! The Test Data will be generated into an Excel worksheet allowing you to modify, enhance or tweak the data. You can then use the QueryCell SQL Insert Generator to create SQL Insert statements for the data and get it into a database.

Download Trial 8.23 MB

Buy Now $45.00 USD

Software Information		System Requirements
Version:	1.3	Windows 8/7/XP/Vista Excel 2003, 2007 128 MB RAM
License:	Free to try, $45.00 to buy
Download Size:	8.23 MB
Screenshot :	View Screenshot
Rating :

Key Functions of QueryCell:

Using SQL in Excel
Marking Rows that match your criteria
Creating Test Data
Generating SQL Insert Statements

RELATED SOFTWARE DOWNLOADS FOR QUERYCELL

Data Quik - Database Copier
Copy Database Records and selected fields between DBase, Paradox, Access, Excel and some Lotus Files.

Quick Query
It provides a simple way to perform SQL based queries on the fly, without the need to create and save a query using the standard MS Access interface.

Visual Open DB
is a generic data analysing application that allows you to query any valid data source

Active Query Builder Standard .NET Edition
is a visual SQL query builder component that allows your end-users to build complex SQL queries via an intuitive visual query building interface easily.

Oracle Query Analyser
is a professional development tool allows rapid transact SQL development against an Oracle database.

SQL Uniform
database query, comparation, export, convert, admin tool.

IntraWeb Query Builder
provides ad-hoc query capabilities in IntraWeb web applications.

RazorSQL for Mac OSX
is an SQL query tool, database browser, SQL editor, and database administration tool for Mac OS X.