Home » RDBMS Server » Server Utilities » .xls file into table by using sqlloader
.xls file into table by using sqlloader [message #616325] Sun, 15 June 2014 22:17 Go to next message
sasank54
Messages: 4
Registered: July 2013
Location: Banglore
Junior Member
Hi,

I am having an Issue with .Xls file how to load that data into table by
Using Sql loader, without converting into Csv file any method










Regards,
sasank
Re: .xls file into table by using sqlloader [message #616327 is a reply to message #616325] Sun, 15 June 2014 22:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

we don't have your file.
we don't have your table.
we can't write your solution since we don't know what is the input or desired results.
Re: .xls file into table by using sqlloader [message #616333 is a reply to message #616325] Mon, 16 June 2014 00:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Oracle version?

Re: .xls file into table by using sqlloader [message #616416 is a reply to message #616325] Mon, 16 June 2014 13:36 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
If you are going to use SQL*Loader, then you need to convert it to a delimited or fixed-position file first. If you can't do that, then you need to use some other tool, like SQL*Developer:

http://www.thatjeffsmith.com/archive/2012/04/how-to-import-from-excel-to-oracle-with-sql-developer/

[Updated on: Mon, 16 June 2014 13:37]

Report message to a moderator

Re: .xls file into table by using sqlloader [message #616419 is a reply to message #616325] Mon, 16 June 2014 14:13 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
sasank54 wrote on Mon, 16 June 2014 08:47
without converting into Csv file any method


Can you tell what is the problem with converting it as CSV format? If not then you could simply do save as comma delimiter type and go ahead with sqlldr.
Previous Topic: SQL Loader - Unable to load data
Next Topic: SQL Loader to fail in Warning and send email notifications
Goto Forum:
  


Current Time: Thu Mar 28 14:28:30 CDT 2024