Home » RDBMS Server » Server Administration » loading excel data into oracle database
loading excel data into oracle database [message #371965] Wed, 27 December 2000 18:09 Go to next message
Sukumar Jana
Messages: 2
Registered: December 2000
Junior Member
Hi,
I'm wondering how to save microsoft excel data into oracle database. could anyone help with some idea?
Thanks

Report message to a moderator

Re: loading excel data into oracle database [message #371976 is a reply to message #371965] Fri, 29 December 2000 00:44 Go to previous messageGo to next message
xingxing3
Messages: 2
Registered: December 2000
Junior Member
method I:
1.use ACCESS importing into ACCESS DB
2.save as ODBC source,,and go on...

method II:
1.save the EXCEL format as 'data.gsv'
2.if u use a windows client then
'\orawin95\BIN\Sqlldr80.exe UserName/PassWord@database control=book1.ctl'
more details see HELP...

Report message to a moderator

Re: loading excel data into oracle database [message #371985 is a reply to message #371965] Mon, 01 January 2001 05:47 Go to previous message
afs
Messages: 1
Registered: January 2001
Junior Member
Hi
Use ADO from Excel Loop thru the worksheet and Insert into Oracle DB.
Hope this answers your query.

Report message to a moderator

Previous Topic: sqlplus query
Next Topic: How to describe all the tables from tab?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 17 00:42:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.