data query Office Suites and Tools

XL-DBQuery is a powerful add-in for Microsoft Excel that makes it easy to perform data analysis and reporting. Unlike Excel's built-in "MS Query" function, XL-DBQuery offers an intuitive query syntax that lets users build complex queries, without having to master Boolean algebra.

Tags: excel, data, ms query, query builder, sql, queries, data analyst, data analysis

Data Manager allows you to convert worksheets into tables, conduct queries, and create forms all within Excel. It offers a range of data validation options to ensure that only valid data is added to your database. Using customized buttons that can be added to your forms, you can open other forms, run macros, open hyperlinks, and send data to Microsoft Word. Current Excel Data List users can easily convert those lists into Data Manager tables.

Tags: Excel, Database, Spreadsheet, Data List, Relational, Add-in, Field, Validation, Query, data management

DataLinks for Access only query tool allows business and IT users to quickly and easily access their Access databases. Writes SQL, easiest UI on the market today with simple preview data review. Data direct to Excel or XML on the fly and easily create live links. Additional data sources available at www.bidata.net. Excel based data access, integration, query, plus dashboards and reporting.

Tags: Excel Data Access, Query, Dashboards, Reporting

Import one or many XML files into a blank MS Excel file. Specify local XML files and either insert them all into one sheet or individual sheets per file. Excel 2000 or higher required.

Tags: converting, import, export, converter, conversion, ms, microsoft, editor, transformed, transform

Similar Data Finder for Excel will help you to find cells with similar values in Microsoft Excel 2000-2007 worksheets. The program enables you to quickly find mistakes made while entering cell values; easily correct the mistakes; find and mark cells which seem to be incorrect; remove the cells with identical values.

Tags: excel, find excel typos, excel add-in, misprint finder, excel download, excel 2007, misprinted cell, microsoft excel, excel 2003, duplicate entries