Easily find issues by searching: #<Issue ID>
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
Aqua Data Studio supports connecting to Microsoft Excel files via Generic ODBC. The Mac operating system does not allow Aqua Data Studio to connect to Microsoft Excel Files with Generic ODBC.
Aqua Data Studio version 17 and higher use Java 1.8. Oracle has removed the JDBC-ODBC bridge driver in Java 1.8. The driver is not bundled with Aqua Data Studio which could cause a missing driver error. Aqua Data Studio can run using Java 1.8 and still use the JDBC-ODBC bridge from Java 1.7 if Java 1.7 is added to the installation. See How to Install the Java JDBC-ODBC Driver for installation instructions.
For Microsoft Excel, a single file is stored on a host machine either as a .xls file or .xlsx file.
Add the ODBC
|Create Server Group||
Register a Microsoft
Properties MS Excel
|Query an Excel File|
Your Installation of Aqua Data Studio bit version ( 32bit or 64bit ) must match your ODBC Driver for Excel. Only 32bit ODBC drivers work with the 32bit version of Aqua Data Studio. Only 64bit ODBC drivers work with the 64bit version of Aqua Data Studio. Mismatching the driver type with the version of Aqua Data Studio will prevent Aqua Data Studio from successfully connecting to your ODBC datasource.
There is currently no way to distinguish User DSN ODBC driver 32bit versions from 64bit versions because of an issue with Windows ( http://support.microsoft.com/kb/942976 ).
To connect to a Microsoft Excel ODBC Datasource using Aqua Data Studio Generic ODBC:
The Microsoft Excel ODBC Data Source is registered successfully in Aqua Data Studio. You can now connect to the newly registered Server and perform Data Manipulations.
Queries on Microsoft Excel ODBC Data Sources do require that the Worksheet name be surrounded by brackets, like
select * from [Sheet1$]
for Aqua Data Studio to successfully execute them.
You can get more information about Microsoft ODBC connections here