Pl sql developer odbc importer
![pl sql developer odbc importer pl sql developer odbc importer](https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/media/connect-to-oracle-with-odbc.jpg)
In the Specify a Connection String window, click the Build button. When the Table Import Wizard opens, select Others (OLEDB/ODBC) and click Next. In the opened window, click From Other Sources.
![pl sql developer odbc importer pl sql developer odbc importer](http://www.gokhanatil.com/wp-content/uploads/2014/09/postgresisready.png)
The required data is successfully imported to Excel.Ĭonnecting Excel to Oracle with Microsoft Query Select Return Data To Microsoft Excel and click Finish. If you plan to further use the query, you can save it by clicking the Save button on the right. The next two steps allow filtering and sorting the data.
![pl sql developer odbc importer pl sql developer odbc importer](https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/media/connect-to-oracle-with-net-provider.jpg)
In the appeared dialog, you can choose the data source you want to connect to.Īfter a successful connection, you can select the data you want to be displayed in Excel and click Next.
#Pl sql developer odbc importer driver
If you haven't configured your ODBC driver yet, you can expand the Advanced Options dialog box and enter the connection string for your data source (without credentials, which are defined in the credentials dialog box in the next step).