Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
829
|
Aqua Data Studio now supports Microsoft Excel, giving you the ability to connect, query and generate results from XLS and XLSX files. With Aqua Data Studio 15.0, you can register a Microsoft Excel connection to a directory containing Excel files and use features such as the Query Analyzer, VA, Export Tool and Query Builder. Once connected to a folder of several Excel files, the Schema Browser will consider the folder a database, each file a schema, and each sheet within each file as a table. We also have some customized ExcelSQL commands only for use with Excel connections. By letting you connect to your XLS and XLSX files we're making one of the most frequently exchanged file formats on the planet even more useful.
Explore your Microsoft Excel file schema by using the Schema Browser: a visual tree that shows the contents of all of file sheets. Right click on an object to view its properties.
Right click on a Microsoft Excel object in the Schema Browser and you can script it as SELECT to have Aqua Data Studio generate SELECT DDL for you.
Connect to Microsoft Excel and execute SQL queries effortlessly by using intelligent Autocomplete, SQL Abbreviations and SQL Automation. Perform advanced analysis by using the built-in Pivot Grid and Charts, or one-click export to Excel.
Learn more
Use our UI's built-in ETL functionality to import data, massage it to suit your needs and even export it in a different format. Use Aqua Data Studio's wizards to walk you through, step by step, importing data into existing Microsoft Excel tables and exporting Microsoft Excel data based on your desired format.
Learn more
After you've generated results from a query, use the Results Compare Tool to search, filter and sort differences. Generate HTML reports of the comparison to share with others.
Learn more
Use Open APIs to create fully automated end-to-end solutions for your Excel databases using JavaScript. Aqua Data Studio provides a full-fledged IDE with APIs to Microsoft Excel file access, schema DDL generation, Grid and Pivot Grid charts, version control and much more.
Learn more
Generate great looking charts and graphs from your Microsoft Excel file content. Choose from a variety of chart types and customize until you've designed exactly what you need to visualize your data. All charts are updated in real time based on your query results. You can even pivot your data and create charts based off of your pivoted data.
Learn more
Automate your database ETL tasks using FluidShell, an interactive shell which combines the power of an SQL command line with the versatility of a Unix shell.
Learn more
Construct sophisticated database queries without ever writing a line of SQL. Use our UI to select tables and columns and leverage our rich set of visual options including SORT ORDER, equality comparisons and more.
Learn more
Automatically record and archive all of the queries you run on Microsoft Excel servers and store them in a centralized location for auditing purposes. View a history of all the SQL statements and scripts that have been executed within the Query Analyzer, and Query Builder. Execute a query from months or even years ago.
Learn more
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017