XL-DBQuery by SBS Development

URLs: sbs-xl-dbquery, sbs xl dbquery, sbsxldbquery, sbs-development, sbs development, sbsdevelopment

Analyse your corporate data with an easy to use analysis and reporting tool for Excel. XL-DBQuery from SBS Development is a data analysis and reporting tool for Excel that enhances Excel’s existing analysis and reporting capabilities and is a viable alternative to Excels own ‘MS Query’. It is based on the popular Query Builder ‘Automated-SQL-Builder’. 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 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.

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

Analyse your corporate data with an easy to use analysis and reporting tool for Excel.

Operating System for Deployment: Windows Vista, Windows XP, Windows Server 2003, Windows 2000, Windows 98, Windows NT 4.0, Windows NT 3.51

Architecture of Product: 32Bit

Product Type: Add-In

Compatible Containers: Microsoft Office 2007, Microsoft Office 2003, Microsoft Office XP, Microsoft Office 2000

Keywords: Excel Add In SQL Query MS Office

Mining analyze analyse analysis　データ分析

Database DB Connectivity

SQL query language

Database DB Reporting Report reports