How to import data from an Oracle database (or any other database) to an Excel file

The following is a method for importing Oracle Data to excel on the Internet. I have used it.

It is also found that access can directly import Excel data when creating a table,

In this way, there is a bridge to convert data between various databases.

In today's era of rapid development of information technology, users often encounter the problem of splitting data in Excel files with data in the
Oracle database, operations on real-time data are implemented, but there are not many materials available for reference
. If you need to reverse the data in the Oracle Information System and analyze it using Excel, I
Use ODBC to import the data into the Excel file, for beginners, the effect is good. Here we will give you a
the so-called ODBC is the abbreviation of Open Database Connectivity, that is, Open Database interconnection. The prerequisites for using ODBC
Dynamic Data Exchange are simple. You only need to install Microsoft Office Excel on your local computer, next, run
as needed. Next, we will introduce the actual problems encountered in my work:
1. First, configure the ODBC data source. On the Control Panel, select the ODBC data source and add and install ODBC for Oracle
. You can customize the data source name and description when specifying the data source name. the user name and server must be in the Oracle database
For example: Data Source Name: Example
description: example
User name: Scott
server: Tiger
2. Open excle, select obtain external data source from the data menu, and create a database query.
3. The system prompts you to select a data source. Select the data source example we have set and enter the Database Password.
if this is the first time you run the SQL Program , cancel the SQL statement and run the SQL statement in Microsoft query.
4. Select the data to be dumped based on your work needs and write an SQL statement. Example:
select. item_no,. item_desc,. item_um,
. item_created_by,. created_date
from ic_item_mst A
5. Execute the query for this section. You can see that all the matching records have been reversed in the Excel table, first behavior record
6. If you re-execute the file, you only need to open the query and execute it in the Micrsoft query window,
7. You can use the powerful editing function of EXCEL to analyze and modify the data, which is quite convenient.