skip to main content
Quick Start: Progress DataDirect for ODBC for Oracle Wire Protocol Driver for Windows : Accessing Data With Third-Party Applications : Accessing Data in Microsoft Excel from the Query Wizard
  

Try DataDirect Drivers Now

Accessing Data in Microsoft Excel from the Query Wizard

After you have configured your data source, you can use the driver to access your data with Microsoft Excel from the Data Connection Wizard. Using the driver with Excel provides improved performance when retrieving data, while leveraging the driver's relational-mapping tools.
To use the driver to access data with Excel from the Data Connection Wizard:
1. Open your workbook in Excel.
2. From the Data menu, select From Other Sources>From Data Connection Wizard.
3. The Welcome to Data Connection Wizard dialog appears.
Excel Data Connection Wizard
Select ODBC DSN from the data source list; then, click Next.
4. From the ODBC data sources list, select your data source. Click Next.
5. The logon dialog app pre-populated with the connection information you provided in your data source. If required, type your password. Click OK to proceed.
Note: The logon dialog may reappear if Excel needs to access additional information from the data source. If this occurs, re-enter your password; then, click OK to proceed to the next step.
6. The Select Database and Table window appears.
Select Database and Table window
*To access data from multiple tables, uncheck the Connect to a specific table box; then, click Next.
*To access data from a specific table, select the table you want to import from the list; then, click Next.
7. Enter the file name, description, and, optionally, the friendly name and search keywords for your Data Connection file in the corresponding fields. Click Finish.
*If you chose to access data from multiple tables in Step 6, proceed to the next step.
*If you chose to access data from a specific table in Step 6, skip to Step 9.
8. The Select Table window appears.
Select Table window
Select the tables that you want to import into your workbook; then, click OK.
9. The Import Data window appears.
Import Data window
Select the desired view and insertion point for the data. Click OK.
You have successfully accessed your data in Excel using the Data Connection Wizard. For more information, refer to the Microsoft Excel product documentation at: https://support.office.com/.