OraFAQ Forum: Server Utilities » .xls file into table by using sqlloader

Home » RDBMS Server » Server Utilities » .xls file into table by using sqlloader

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

.xls file into table by using sqlloader [message #616325]

Sun, 15 June 2014 22:17

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

Report message to a moderator

Re: .xls file into table by using sqlloader [message #616327 is a reply to message #616325]

Sun, 15 June 2014 22:22

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.

Report message to a moderator

Re: .xls file into table by using sqlloader [message #616333 is a reply to message #616325]

Mon, 16 June 2014 00:09

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Oracle version?

Report message to a moderator

Re: .xls file into table by using sqlloader [message #616416 is a reply to message #616325]

Mon, 16 June 2014 13:36

Barbara Boehmer
Messages: 9101
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

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.

Report message to a moderator

Previous Topic:	SQL Loader - Unable to load data
Next Topic:	SQL Loader to fail in Warning and send email notifications

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 03:07:15 CST 2024