Access database successfully imported Oracle library method

Intermediary transaction http://www.aliyun.com/zixun/aggregation/6858.html ">seo diagnose Taobao guest cloud host technology Hall

These days in a Web site project need to import a table in the Access database in the Oracle library, check it, there are many web design tutorials in the solution, but not in detail, if you do not succeed, now give a successful import of the detailed solution.

Follows：

First, open Control Panel-Administration Tools-Data Source (ODBC), add a data source driver for Oracle's user DNS, and fill it in with data sources, Server Name, user, and test connectivity.

Then, open the Access database, select the table that you want to export, click "Export" on the "File" menu, in the Save Type Drop-down box, select the bottom of the "ODBC Databases ()", and then in the pop-up dialog box "Select Data Source" in the "Machine data source" in the DNS just established, You will be able to import the database password successfully into the Oracle library after you have identified it.

What you need to be aware of: the name of the Access table table you are exporting must be capitalized! Otherwise, when you import to Oracle, you will see a "ORA-00942: Table or view does not exist" error when you query the table!

This article original address: http://www.code-123.com/html/200892191855580.html, reprint please keep!