Page History

...

• Make sure you have ODBC drivers available for Microsoft Excel, and that you have created an ODBC Data Source from your Excel file.
• Create an ODBC Data Source out of your Excel file so you connect to it within Aqua Data Studio ( See above )
• Create a new server Group and name it as MS Excel ODBC
• Right Click on the server group and click the Item which displays Register Server
• Provide a new name for the Microsoft Excel file's Server Registration
• In the General tab, pick Generic - ODBC
• In the Location Datasource field, browse to locate the ODBC datasource for Microsoft Excel you created.

...