Re: importing excel data into Oracle Database
From: Pasi Parkkonen <pasi_at_eigenvalue.com>
Date: Wed, 20 Feb 2002 14:09:32 +0200
Message-ID: <a503la$4uf$1_at_tron.sci.fi>
Date: Wed, 20 Feb 2002 14:09:32 +0200
Message-ID: <a503la$4uf$1_at_tron.sci.fi>
"Thorrellius" <bla_at_blaeh.com> wrote in message
news:3c6cbbea$1_1_at_news.tm.net.my...
> Hi...
>
> A guy give me some excel files. Each files have 5 columns of data that
fills
> up to 9000 rows.
>
> He wants me to insert all this data into a table in an Oracle 7.3xx
> database.
>
> Is there a tool to make this job easy? I'm just too lazy to write a few
> lines of PERL Scripts to that job.. Thanks
...Then I'm too lazy to help... ;-)
Ok: Save as tab,comma,dot etc separated format in excel and use SQL*Loader to import...
Pasi Received on Wed Feb 20 2002 - 13:09:32 CET