OraFAQ Forum: SQL & PL/SQL » procedure to load excel file into the database

Home » SQL & PL/SQL » SQL & PL/SQL » procedure to load excel file into the database

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

procedure to load excel file into the database [message #220882]

Thu, 22 February 2007 10:28

lokesh.sql
Messages: 9
Registered: November 2006
Location: Pune

Junior Member

Hi All ,

I am stuck with some problems related to data loads from excel, CSV files into an oracle 9i database.I need the procedure to load the data from excel file into the orcle database.Please help me out.

Thanks in advance.

Lokesh

Report message to a moderator

Re: procedure to load excel file into the database [message #220884 is a reply to message #220882]

Thu, 22 February 2007 10:32

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

And what might those problems be?
Use sql*loader or VBA methods or any GUI tool
http://orafaq.com/faq/how_does_one_load_ms_excel_data_into_oracle

Report message to a moderator

Re: procedure to load excel file into the database [message #220887 is a reply to message #220882]

Thu, 22 February 2007 10:53

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

And do not cross-post

Report message to a moderator

Previous Topic:	nb of records
Next Topic:	how can I get sequence's current value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 10:50:20 CST 2024