XL-DBQuery Product News

December 2008 - Version 1.6.0 Released

The eagerly awaited new version of XL-DBQuery (Version 1.6) has just been released. Version 1.6 includes a new feature that allows users to add alias table names to their queries and create multi-table joins based on the same table. (See screen print below). A 15 day trial of version 1.6 is now available to download



April 2008 - Version 1.5.7 Released

Various minor fixes to the Excel criteria value pickup feature (See product history file for details). Version 1.5.7 can be downloaded from our downloads page.

March 2008 - Version 1.5.6 Released

A new feature has been added to XL-DBQuery Version 1.5.6 - Due to customer demand, XL-DBQuery (Version 1.5.6) now includes a new feature that allows users to utilise the 'IN/NOT IN' SQL Operators in their assembled queries. This feature will help to improve both query performance and legibility of the query (SQL) code. Version 1.5.6 can be downloaded from our downloads page.

January 2008

Happy New Year to all our customers !

We are proud to announce the release of XL-DBQuery Version 1.5.5. This version includes various improvements to the Excel value criteria pickup feature. We have now included the 'IN' operator function, which dramatically increases the number of Excel criteria values that can be selected and also helps to improve the overall value pickup performance. The 'IN' operator is automatically added when the user selects Excel cell values using the '=' (Equals) operator. You can download the latest trial version Here (Remember - Exiting customers can upgrade FOC)

September 2007

We are proud to announce the release of XL-DBQuery Version 1.5. Thank you for everyone's patience. XL-DBQuery Version 1.5 includes many new exciting features and enhancements that you are sure to find useful.
Download a 15 day evaluation today

August 2007

We are proud to announce that you can now download a copy of
XL-DBQuery Version 1.5 Beta. Version 1.5 includes all of the new features as detailed below (June 2007), as well as many additional features and enhancements. Please keep in mind that this is however a beta version, so we would be grateful if you could let us know about any issues by e-mailing them to us at support@xl-dbquery.com All going well, we anticipate an end of August 2007 release.

Please note - If you wish to evaluate XL-DBQuery v1.5 beta and your existing v1.1 evaluation period has elapsed. Please contact us for a 15 day extension @ general@xl-dbquery.com

We are proud to announce, that due to a large number of customer requests, we can confirm that XL-DBQuery Version 1.5 will support the popular accounting package 'QuickBooks'. This will help to further strengthen the appeal of XL-DBQuery among the existing QuickBooks community.

QuickBooks users wishing to query and export their QuickBooks data using XL-DBQuery, will need ensure that they have the QuickBooks ODBC Driver (QODBC) installed on their machine. QuickBooks Enterprise users will already have the Driver installed.

June 2007

The next release of XL-DBQuery, scheduled for a July release, will include a few new and exciting features and enhancements. Top of the list is the release of a brand new feature, the 'Query Tree View', which has been designed to enhance a users understanding of their assembled query. As well as the SQL view, the user will be now be able to view their assembled query as a tree view, with selected tables, fields and criteria clearly displayed in a hierarchical manner. This has the effect of making the query a lot easier to digest and understand. The 'Query Tree View' also displays fields that have been grouped and ordered, using individual images to clearly identify them.

Below is a screen shot of the new 'Query Tree View' feature



In addition, we have also added a new query results export option that allows you to export the query results data as a CSV text file. As CSV is a widely used and recognised format, the file can easily be utilized by other application and databases including XL-DBQuery itself. You could for example use XL-DBQuery to create CSV files from different data sources and merge the data together into one Excel sheet.

We are also looking at enhancing the existing Excel cell value criteria selection function, so that there is no longer a 25 cell limit. This means that you will be able to select a virtually unlimited number of Excel cell values and include them as part of your query criteria.

If you have any suggestions for any new features that you would like us to consider adding to XL-DBQuery, why not let us know