|
|
| Re: ms_excel spread sheet to oracle table [message #97781 is a reply to message #97780] |
Tue, 21 January 2003 23:10  |
Joyjeet
Messages: 23
Registered: January 2003
|
Junior Member |
|
|
There are plenty ways to do that.
If U take the intermediate help of MsAccess, it'll will be simple.Follow the steps:
1. First in yr excel evironment,activate the Access Link , ODBC-Addin,Update Add-in Links from Tools->Add-Ins....select the check Boxes.
2. Then open the sheet and select the data Area to be exported.
3. From excel menu Data->Convert To Ms Access...follow the instructions.
4.After u create the Ms Access DB, Select the Table to be exported and Export it with proper ODBC-DSN to yr Oracle DB.
If this way seems to be complicated, just export the sheet to a txt file and load the pre-defined table in Oracle with SQL-LOADER.
Good Luck...
JD.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
