Home » SQL & PL/SQL » SQL & PL/SQL » import from excel
import from excel [message #202523] Fri, 10 November 2006 03:31 Go to next message
deni_sa
Messages: 77
Registered: June 2006
Member
I need to import data from an excel worksheet to a oracle database table.The columns in excel worksheet are the same with the tables fiels. Can you help.Thank you Denisa
Re: import from excel [message #202524 is a reply to message #202523] Fri, 10 November 2006 03:38 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member


I think that the forum has addressed this issue before.
Have you tried searching ? Also Google is full of diffrent solutions to this.



Cheers

[Updated on: Fri, 10 November 2006 03:43]

Report message to a moderator

Re: import from excel [message #202526 is a reply to message #202523] Fri, 10 November 2006 03:41 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Here are a couple of links from the famous search page:
Link 1
link 2
link 3
link 4
link 5
link 6

Some quick tips: the easiest way is to convert to .CSV and use external tables or SQLLDR.

MHE
Previous Topic: number of columns in csv file
Next Topic: SQL Loader
Goto Forum:
  


Current Time: Wed Dec 07 22:01:35 CST 2016

Total time taken to generate the page: 0.10995 seconds