Re: SQL*Loader
From: Christoph Pfrommer <Christoph.Pfrommer_at_oracle.com>
Date: Thu, 29 Mar 2001 22:06:47 +0200
Message-ID: <3AC395D7.7A16235D_at_oracle.com>
Date: Thu, 29 Mar 2001 22:06:47 +0200
Message-ID: <3AC395D7.7A16235D_at_oracle.com>
Steve Hamel wrote:
> I need to import Excel files into an Oracle table. I was told that it was
> possible to so using SQL*Loader.
>
> Does anyone have any good links where I can find the info and procedure to
> follow...could not find anything relevent on TechNet.
You are right, using SQL*Loader is o.k. Save your Excel files as csv (comma seperated) files. Then, see your documentation (and I'm sure this is available at technet.oracle.com) about SQL*Loader loading variable-length data. There are many detailed case studies in the docu.
Hth.
Christoph Pfrommer
Received on Thu Mar 29 2001 - 22:06:47 CEST