Aqua Data Studio for MS Excel

Enhanced in 18.0 Aqua Data Studio provides a SQL management tool for Excel[1] files. The visual administration features provide users the ability to browse workbooks, worksheets and column structures. An integrated query tool allows you to quickly create, edit and execute SQL.

ExcelSQL is a SQL-92 based SQL language that offers a rich syntax to execute queries with WHERE, JOIN, ORDER BY, GROUP BY, HAVING and UNION clauses. Subqueries, derived tables, JOINs across multiple workbooks and many convenient DB functions are also supported.


Support: Schema Navigation | Visual Editing | DDL Scripting

Browsing Visual Editing DDL Scripting
Schema
Tables feature feature
Storage
Databases feature

References

  1. ^ Excel Wikipedia article. Microsoft Excel is a spreadsheet developed by Microsoft for Microsoft Windows, Mac OS X, and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
    Microsoft Wikipedia article.

Home Aqua Data Studio Aqua Data Server AquaClusters Support Buy Company Privacy

Copyright © 2001–2017 AquaFold, Inc. All Rights Reserved.