Here is step by step description:
Step 1) Export spreadsheet to a comma separated file.
Step 2) Ftp comma separated file to a machine which has SQL*Loader
installed.
Step 3) Do a Google search on what to do next. Enter words "Excel oracle CSV loader
Playboy Centerfold" into the search field.
Step 4) Email each of the URLs that will be returned by Google as a
separate topic on this list.
Important warning: Don't you ever go to OTN or Metalink or actually read SQL*Loader
documentation. It's very detrimental to your health.
On 2003.05.19 06:11 FAIZ QURESHI wrote:
> Hello:
> I have a requirement where in I have to populate data from an Excel sheet
> into a database table.
> Can you seuggest me which is the best way to do this and also provide with a
> step by step description of the procedure that is involved in doing this. I
> would also appreciate if you could forward me a demo file which does this
> kind of an operation.
> Regards,
> Faiz
>
> _________________________________________________________________
> STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
> http://join.msn.com/?page=features/junkmail
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: FAIZ QURESHI
> INET: faizq_at_hotmail.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Mladen Gogala
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: mgogala_at_adelphia.net
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon May 19 2003 - 06:36:51 CDT
