Let me ask you a question - how do you go about using your Microsoft Excel spreadsheet data as part of a database? Probably the same way as everyone else does, right - export the data to a flat file, then import that into a SQL database and then go about your business. What would you say if I told you that one simple plug-in could turn Excel into an SQL database application?
It's true! With QueryCell, you'll be able to run SQL queries against your spreadsheet data without ever leaving Excel! And these are real SQL functions, too, like Group By, Min, Max and Avg. You start by choosing which spreadsheet cells should be queried as tables. Then, just type the SQL that you wish to use into the SQL Editor, hit run, and your results show up in a new worksheet. Step three - there is no step three! You're done.
QueryCell2.0 now features a number of powerful Excel-specific features. You to query Excel data using SQL, and also query databases and return the result set to Excel. You can mark Excel ranges that match a SQL "where" clause, and even use the SQL insert generator to convert Excel data into SQL Insert statements in seconds. If you use databases and Excel you need QueryCell!
QueryCell is so flexible, you may never need to export data to an external database application again. For instance, you can run a single SQL query against the active workbook. You can devise custom tables that allow you to specify column data types and names. Your most often used SQL statements can be stored as part of a template library for easy access!
Review Written by Derek Lee
- Query Databases directly from within Excel.
- Run SQL queries against spreadsheet data without ever leaving Excel.
- Run SQL and execute stored procedures.
- Convert Excel data into SQL insert statements in seconds.
- Find and mark Excel rows that match a SQL where clause.
- You can download and install a free trial of this software before purchasing
- Download available for: Windows XP, Vista, 7, Excel 2002, 2007, 2010 - both 32 and 64 bit Office
- Buy with BitsDuJour's promotional coupon code and get all this at a discounted price!
- After you purchase QueryCell 2.0 it may be used indefinitely.
- QueryCell 2.0 is licensed per user, so if more people are going to use QueryCell 2.0 you will need to purchase additional copies.
- Transfer of a license to another owned computer is allowed.
- License activation isn't required. what's this?
- Upgrades to future versions of the software will be free for 12 months. For versions after that, upgrades will require additional payment, which will be discounted by 75%.
- Support is provided up to when the next major version is released, and minor versions thereafter.
- 30 days return policy.
- Prices do not necessarily include taxes, which will vary by country.