Re: SpreadSheet >>> Oracle DB ??
Date: 1995/04/11
Message-ID: <3mcn15$ere_at_vent.pipex.net>#1/1
RLPA80_at_email.sps.mot.com (John-Reed Maffeo) wrote:
>
> What is the best way for an individual user to put data
> that is in a spread sheet (Excel, Lotus (Mac, DOS)) into
> an oracle DB running on a remote host?
>
>
I would suggest exporting (or saving as) the information from the spread sheet as a text file or text delimitted file, using KERMIT or XMODEM or similar to transfer to the host and importing the information using SQL*LOADER.
This would involve designing template spread sheets including the neccessary macros to export the information, shellscripts and/or dos-scripts (or whatever) to transfer the information (as well as the user procedures needing to be defined) and the SQL*LOADER control files to be written, as well as this, in all probability, some SQL*PLUS scripts would need to be written to process and verify information once in the database.......
...Despite all the above, once set up this will probably work well...
Yours ever
eddy Received on Tue Apr 11 1995 - 00:00:00 CEST