What's new in XL-DBQuery V1.5x?

• New feature added - The 'Query Tree View'. Allows users to view assembled queries in a hierarchical manner. Improves overall understanding of query syntax
• New feature added - Export and convert query results as a CSV text file. Gives further opportunities to import results into other software or merge data from different sources
• New feature added - Users are now able to sort available fields in database order (default) or ascending order
• New feature added - Both table and field lists will automatically include a horizontal scroll bar if any table or field names exceed the width of the table or field list
• Enhancement to existing feature - Users can now select up to 500 values from an Excel worksheet. Previous limit was 25 values
• Many additional minor enhancements designed to improve overall performance and user experience

What's new in XL-DBQuery V1.1?

• New feature added to XL-DBQuery that allows users to create parameter queries that can be dynamically updated from Excel. (Requires ODBC connection)
• New Save/Save As Data Source library file feature added
• New feature added that allows users to return query results to Excel without needing to run and preview the query first
• Query builder load speed has been improved when connecting to Data Sources containing large numbers of tables and fields
• Improved data source connection wizard to easily connect & query Microsoft Excel and Access
• Fully compatible with Microsoft Office 2007
• Fully compatible with Windows Vista O/S

XL-DBQuery is an Add-in for Excel that sits neatly inside Excel’s existing tool set. XL-DBQuery has been designed to expand on Excel’s existing data analysis and reporting capabilities by providing users with ‘self-service’ access to corporate data. With little effort, users can easily connect, query and analyse corporate data and use Excel’s familiar functionality to create reports based on the data returned by XL-DBQuery.

XL-DBQuery is intuitive and simple to use. Users will no longer need the assistance of specialists or I.T. Departments to service their requests for information

XL-DBQuery has been designed with both novice and advanced users in mind and even the most complex requests for information can be quickly and efficiently serviced.

XL-DBQuery uses assumptions influenced by the query criteria already entered by the user. This also extends to the selection of AND/OR conditions, an area that is often confusing for many novice and occasionally even experienced users. This approach means that assembled queries nearly always reflect the user’s requirements and often means that no further modifications are required to the assembled query.

Here are just a few more examples of the benefits that XL-DBQuery can bring to your business:

• A simple and intuitive user interface
• A viable alternative to Excels ‘MS Query’
• Compatible with Excel 2000 and above, Including Excel 2007
• Utilises users existing Excel skills and extends Excels built-in analysis and reporting capabilities by providing a bridge to your corporate data
• ‘Self-service’ style analysis and reporting for novice and advanced users alike
• Query assumptions help users build the queries they want quickly and efficiently without having to learn new skills
• Adheres to existing Database security measures
• Export data to Excel as standard row column reports or multi-dimensional pivot table reports for dynamic analysis of corporate data
• Refresh exported results directly from Excel
• Share corporate data with colleagues and co-workers
• Join and merge data from different data sources
• Query and analyse virtually any corporate data source within your organisation
• Digitally signed (VeriSign) for extra peace of mind

Standard Edition - includes all features with the following exceptions:

• Unable to create a connection to external datasources, i.e. SQL Server, Oracle, etc
• Unable to create joins between tables/views
• Unable to manually edit query SQL using the SQL Scratch Pad feature

Professional Edition - Unlimited functionality.