-
External data load
Dear All,
I was wondering how I can load data from MS Excel, Access to Oracle DB except for Oracle SQL*Loader. Thank you for your help in advance!!
-
USE ODBC.
1. see that you have installed either -
Micrsoft ODBC for Oracle or
ORacle ODBC driver
2. Create DSN using controlfile.
3. You can create an UDL file for testing.
4. If succeded. use this DSN to export data to Oracle table from MSAccess.
for Excel , you can import data into MSACCESS and the follow above procedure
Santosh Jadhav
8i OCP DBA
-
Thank you!! Santosh
I did successfully import the external data into Oracle DB.
However, something weird happened...
In TOAD, I can see the import schema & data, but..................
In Sql*Plus, I issue "select table_name from user_tables" from that owner. It did display the new-added table name --NEW, but after I run " select * from NEW or desc NEW, I got the error message: ORA-00942: table or view does not exist.....
Any ideas for all of you ?? Thank you a million!!
[Edited by peggy on 05-23-2002 at 05:19 AM]
-
may be when you exported the tables into oracle the table names are in small case or (initcap) , it would have taken the same.
instead, try to use
select * from "NEW"
it should work.
Santosh Jadhav
8i OCP DBA
-
Thank you so much!! Santosh
It did work, and I do learn a lot....& appreciate for your time & effort......
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|