How to import access data from Oracle (table and data)
How to import access data from Oracle (table and data)
Time: 2004/07/07 Author: cowbird
The database we use is Oracle, but it is not suitable for demonstration due to its large local installation. create a local access database. because tables and data are both ready-made and are in Oracle, how can we import them to access?
I found it on Google, but I have not found a good method. so I thought of DataPump, a tool under Delphi7, and I thought it was good. next I will tell you how to import data. I believe there must be other more convenient methods. Thank you for your exchange!
1) create two data sources through SQL Explorer
P350 and p350access
P350 is an elasticsearch database.
P350access is an Access database (which must be configured in ODBC and specified in the MDB File)
2) DataPump Data Import
Select the Oracle database p350 to import and the imported Access Database p350access,
Select the table to be imported.
Press the prompt and press OK to export the data (you may need to adjust it in the middle, or the keyword segment is missing). Open Access and check that the table and data are in it.
Original article: http://www.cnblogs.com/cowbird/archive/2004/07/07/21949.aspx