Re: Importing files from LOTUS
Date: Tue, 5 Jan 1993 07:53:36 GMT
Message-ID: <1993Jan5.075336.21343_at_lmpsbbs.comm.mot.com>
In article <31379_at_nntp_server.ems.cdc.com> rsnyder_at_ems.cdc.com writes:
>We have an application that requires data to be imported to Oracle
>tables from a LOTUS spreadsheet. I don't believe there is any
>Oracle utility to do this. However, I would like the benefit of others
>experience as to how to go about this. The following comes to mind:
>
>1) Are there any Oracle utilities to do the import written by
> Oracle, LOTUS or others?
>2) If not what is the best approach to import the LOTUS data?
> a) Write a script in LOTUS to do the import directly.
> b) Put the LOTUS data into a flat file and then reformat the flat
> file to an Oracle Import format.
> c) Some other method.
>
>Any information, ideas, experience will be helpful.
>
> Thanks,
>
> Richard Snyder
> rsnyder_at_ems.cdc.com
>
>Empros Systems International division of Ceridian Corp.
>
>(612)553-4327
>
>
Well how about exporting to a text file and then using SQL*LOADER ?? There are probably better ways, but off the top of my head this should work.
My opinions are all mine - for good or for bad - usually for the worst !
+------------------------------------------------------------------+ | Garth Kennedy garth_at_comm.mot.com Voice (708) 576-3786 || Private Trunked Systems Div. Motorola Inc. FAX (708) 576-6028 |
+------------------------------------------------------------------+Received on Tue Jan 05 1993 - 08:53:36 CET