Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3003
  • Last Modified:

Import data from excel to oracle table

Hai,
We are developing one package in oracle form builder 6i with oracle 9i as back end.Our form contains a button and a text item which reads the file name with location of an Excel file .While pressing the button we have to take the data from the above excel file into one oracle table. Format of the excel file and structre of the oracle table is already defined.We are using windows XP professional platform.
Pls advise how to take data from excel to oracle table.

Thanks in advance.
0
Jinesh Kumar Kochath
Asked:
Jinesh Kumar Kochath
  • 2
  • 2
4 Solutions
 
MarkusIdCommented:
You can use the DDE-Package of Oracle Forms.

Here you can find an example on how to use it: http://www.orape.net/article35.html
0
 
SJT2003ACommented:
Did you try with Export option in the EXCEL?
Try to save it an acceptable format to ORACLE and check it.
I knew that import option in EXCEL would import values from text format into EXCEL sheet.

May be you should start check reference in EXCEL help etc. Since I use OpenOffice I can not check with the EXCEL. Try it out.

Good luck :)
0
 
Jinesh Kumar KochathSr. IT Manager (Middle East & South East Asia)Author Commented:
Hello,
I tried the link  http://www.orape.net/article35.html .But while pressing the button i am getting one message WINDOWS APPLICATION CAN NOT START. Pls advise me.
0
 
MarkusIdCommented:
Hello,

Which path for the excel.exe did you use? I just noticed that there might be a little mistake in the link i gave you, as they obviously stripped the backslashes. You should use a common windows-path for the path to the excel-file.
0
 
Jinesh Kumar KochathSr. IT Manager (Middle East & South East Asia)Author Commented:
hi,
I tried the method in  http://www.orape.net/article35.html .But first, becuase of wrong path name, i got one error message.But now It is working fine.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now