Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Excel import

Excel import

From: C r a i g e r s <dotacion.nospam_at_st-helena.zzn.com>
Date: 2000/06/07
Message-ID: <8hmjup$lm3@gap.cco.caltech.edu>#1/1

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.5
Received on Wed Jun 07 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US