Loading data form Excel to Oracle tables using Forms 6i
Posted on 2003-12-09
I have a task to load data form MS Excel into Oracle tables using Forms 6i. I've search throught the documentation and one of the slutions offered was using DDE (Dynamic Data Exchange).
The issue I have with an example that it requires to hard code Excel directory
with an assumtion that it's located on drive C , D, etc.
APPID := DDE.APP_BEGIN(C:\MSOFFICE\EXCEL\excel.EXE', DDE.APP_MODE_MINIMIZED);
Are there any way that allows me to find out where excel executable is located.
I was trying to use just "excel.exe", but it doesn't work.
Are there any better solutions on how to load data from excel to Oracle table using forms. (please do not suggest SQL*Loader)