Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Excel import
How would I handle an Excel spreadsheet import. The source file is a worksheet, from a standard template, and once the data has been sucked out into a csv, from there it would be used for importing through the FIN OI.
I need help with the sucking...
A couple of ideas were:
GLDI (and/or its successor), and I have no knowledge of that process other than it _is_ in use on this site, can someone point me there?
One other possibility is executing an Excel macro from the concurrent manager. Can that be done (see my env. below in sig.)? The macro would extract (parse) the data into the csv file.
I have to limit the end users involvement, and not modify their existing spreadsheet at all, just suck out the data and parse it with sed prior to importation.
Last, does anyone know what the 'IMMEDIATE' Execution Method is for, in the concurrent program executable form?
-- C r a i g e r s Oracle Environment Oracle 7.3.4; 10.7 NCA Solaris Designer: Reports 2.5, Forms 4.5Received on Wed Jun 07 2000 - 00:00:00 CDT
![]() |
![]() |