Home » Infrastructure » Unix » ms_excel spread sheet to oracle table
ms_excel spread sheet to oracle table [message #97780] Tue, 21 January 2003 13:09 Go to next message
Anna
Messages: 30
Registered: March 2001
Member
Hi,

can anyone tell me how do i convert the ms_excel worksheets to oracle table.

regards,
anna.

Report message to a moderator

Re: ms_excel spread sheet to oracle table [message #97781 is a reply to message #97780] Tue, 21 January 2003 23:10 Go to previous message
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.

Report message to a moderator

Previous Topic: Oracle Errors in Unix
Next Topic: Re: Installation of Oracle8i on Redhat 7.1
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 18:30:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.