Page History
...
- Within Windows, go to Start > Control Panel > Administrative Tools > Data Sources (ODBC) and right-click Data Sources to Run as Administrator
- Click on the System DSN tab if you want any other user of that computer to be able to access the ODBC data source.
Click on the User DSN tab if you want only your username on that computer to be able to access the ODBC data source. - Click the Add button within the DSN tab.
- Within the list of available drivers, choose "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)" and click Finish
- Within the ODBC Microsoft Excel Setup dialog, enter a Data Source Name, enter a description and click Select Workbook...
- Browse to the Excel file you wish to use and click OK
- Within the DSN tab, you should now see the Data Source Name you entered above in step 5. Click OK
- Now, within Aqua Data Studio, continue with the server registration process
...
For Microsoft Excel, a single file is stored on a host machine either as a .xls file or a .xlsx file.
| Add the ODBC data source | Create Server Group | Register a Microsoft Excel File | Enter Properties |
| Generic ODBC Properties MS Excel | Query an Excel File |
...
| Info |
|---|
Queries on Microsoft Excel ODBC Data Sources do require that the Worksheet name be surrounded by brackets, like |
Microsoft's ODBC Driver
...