To connect to a Microsoft Excel ODBC Datasource using Aqua Data Studio Generic ODBC: There is currently no way to distinguish User DSN ODBC driver 32bit versions from 64bit versions because of an issue with Windows ( ). Mismatching the driver type with the version of Aqua Data Studio will prevent Aqua Data Studio from successfully connecting to your ODBC datasource. Only 64bit ODBC drivers work with the 64bit version of Aqua Data Studio. Only 32bit ODBC drivers work with the 32bit version of Aqua Data Studio. Your Installation of Aqua Data Studio bit version ( 32bit or 64bit ) must match your ODBC Driver for Excel. Register a connection for your ODBC Data Source in Aqua Data Studioįor Microsoft Excel, a single file is stored on a host machine either as a. Now, within Aqua Data Studio, continue with the server registration process Within the DSN tab you should now see the Data Source Name you entered above in step 5. Within the ODBC Microsoft Excel Setup dialog, enter a Data Source Name, enter a description and click the 'Select Workbook.' buttonīrowse to the Excel file you wish to use and click 'OK' Within the list of available drivers, choose 'Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)' and click Finish Within Windows, go to Start > Control Panel > Administrative Tools > Data Sources (ODBC) and right click on Data Sources to Run as AdministratorĬlick on the System DSN tab if you want any other user of that computer to be able to access the ODBC data source.Ĭlick on the User DSN tab if you want only your username on that computer to be able to access the ODBC data source. Register a connection for your ODBC Data Source in Aqua Data StudioĬreate an ODBC Data Source from your Excel file.Create an ODBC Data Source from your Excel file.The Mac operating system does not allow Aqua Data Studio to connect to Microsoft Excel Files with Generic ODBC. Aqua Data Studio supports connecting to Microsoft Excel files via Generic ODBC.

Excel odbc manager