XL-DBQuery
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.
Pricing
XL-DBQuery V1.5.3 - Standard
| Add to Cart | $ 129.00 | 1 User License | Download (38.2 MB) | |
| Add to Cart | $ 539.00 | 5 User License | Download (38.2 MB) | |
| Add to Cart | $ 999.00 | 10 User License | Download (38.2 MB) | |
| Add to Cart | $ 2,299.00 | 25 User License | Download (38.2 MB) | |
| Add to Cart | $ 3,999.00 | 50 User License | Download (38.2 MB) |
XL-DBQuery V1.5.3 - Professional
| Add to Cart | $ 169.00 | 1 User License | Download (38.2 MB) | |
| Add to Cart | $ 30.00 | 1 User License - Upgrade from Standard | Verify | Download (38.2 MB) |
| Add to Cart | $ 699.00 | 5 User License | Download (38.2 MB) | |
| Add to Cart | $ 1,299.00 | 10 User License | Download (38.2 MB) | |
| Add to Cart | $ 2,999.00 | 25 User License | Download (38.2 MB) | |
| Add to Cart | $ 5,199.00 | 50 User License | Download (38.2 MB) |
XL-DBQuery V1.5.3 - Educational or Non-profit Organization - Standard
| Add to Cart | $ 103.20 | 1 User License Educational or Non-profit Organization | Verify | Download (38.2 MB) |
| Add to Cart | $ 431.20 | 5 User License Educational or Non-profit Organization | Verify | Download (38.2 MB) |
| Add to Cart | $ 799.20 | 10 Standard User License Educational or Non-profit Organization | Verify | Download (38.2 MB) |
| Add to Cart | $ 1,839.20 | 25 Standard User License Educational or Non-profit Organization | Verify | Download (38.2 MB) |
| Add to Cart | $ 3,199.20 | 50 Standard User License Educational or Non-profit Organization | Verify | Download (38.2 MB) |
XL-DBQuery V1.5.3 - Educational or Non-profit Organization - Professional
| Add to Cart | $ 135.20 | 1 User License Educational or Non-profit Organization | Verify | Download (38.2 MB) |
| Add to Cart | $ 559.20 | 5 Professional User License Educational or Non-profit Organization | Verify | Download (38.2 MB) |
| Add to Cart | $ 1,039.20 | 10 Professional User License Educational or Non-profit Organization | Verify | Download (38.2 MB) |
| Add to Cart | $ 2,399.20 | 25 Professional User License Educational or Non-profit Organization | Verify | Download (38.2 MB) |
| Add to Cart | $ 4,159.20 | 50 Professional User License Educational or Non-profit Organization | Verify | Download (38.2 MB) |
All sales are made on our standard Terms and Conditions and subject to our Return Policy.
Licensing
One software license is required per machine.
Run-time royalty free.
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.
Asset Value
Man Months Research and Development: 18
Lines of Code: Data not supplied by Publisher
Primary Development Language Used: Visual Basic
Evals & Downloads
| Read the XL-DBQuery License Agreement | (3 KB) |
| Download the XL-DBQuery V1.5.3 evaluation on to your computer - Limited Functionality | (38.2 MB) |
Overview
;)
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.
Compatibility
- 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
Prerequisites
Disk Space Required: 29MB
Memory Required: 32MB