## Data Connection Wizard 

* Open blank workbook in Microsoft Excel.
* Click on **Data** > **Get Data** > **Legacy Wizards** > **From Data Connection Wizard (Legacy)**

<img src="img/data_connection_wizard_select.png" width="400">

* Select **ODBC DSN** and Click on **Next**.

<img src="img/data_connection_wizard_dsn.png" width="500">

* Select **OpenSearch SQL ODBC DSN** and Click on **Next**.

<img src="img/data_connection_wizard_select_dsn.png" width="500">

* Select required table and Click on **Next**.

<img src="img/data_connection_wizard_table_list.png" width="500">

* Add the description. Edit file names if required. Select whether to use this connection file while refreshing data. Click on **Finish**.

<img src="img/data_connection_wizard_save_connection_file.png" width="500">

* Select the worksheet to load data. Click on **OK**.

<img src="img/data_connection_wizard_select_worksheet.png" width="300">

* Data will be loaded in the spreadsheet.

<img src="img/data_connection_wizard_load_data.png">

**NOTE**: If **Legacy Wizards** is disabled in Microsoft Excel, It can enabled by **File** > **Options** > **Data** > **Show legacy data import wizards** > Check **From Data Connection Wizard (Legacy)**.

<img src="img/data_connection_wizard_enable.png" width=600>