Home » SQL & PL/SQL » SQL & PL/SQL » procedure to load excel file into the database
procedure to load excel file into the database [message #220882] Thu, 22 February 2007 10:28 Go to next message
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


Re: procedure to load excel file into the database [message #220884 is a reply to message #220882] Thu, 22 February 2007 10:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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
Re: procedure to load excel file into the database [message #220887 is a reply to message #220882] Thu, 22 February 2007 10:53 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
And do not cross-post
Previous Topic: nb of records
Next Topic: how can I get sequence's current value
Goto Forum:
  


Current Time: Sat Dec 10 22:27:28 CST 2016

Total time taken to generate the page: 0.08427 seconds