Re: Spreadsheet load into Oracle7 RDBMS

On Mon, 11 Mar 1996 10:36:10 -0500, Brian Heath <73144.665_at_compuserve.com> wrote:
>I am looking to see if anyone knows of a utility or software package
>that will take a Lotus 1-2-3 or MS Excel file and load it into an Oracle
>database. I have clients that need to do this and I'm looking for a
>more seemless way than saving file as comma delimited and then
>using SQL*Loader.

You could us MS Access. Create a macro which imports the spreadsheet into an Access table, then runs a query which populates the Oracle table. You can also do data conversion or other manipulation in the query.

--
Deborah Luik, Lead DBA        
ADP Claims Solutions Group                 Phone: (800) 366-4237 x2150
2010 Crow Canyon Place                     FAX  : (510) 866-4839
San Ramon, CA  94583 (USA)                 Email: dluik_at_sr.csg.com