Re: IMPORTing
From: MMK Productions <nospammmkprod_at_bellatlantic.net>
Date: Mon, 28 Sep 1998 22:17:10 -0400
Message-ID: <6upfvn$k8i_at_world6.bellatlantic.net>
Date: Mon, 28 Sep 1998 22:17:10 -0400
Message-ID: <6upfvn$k8i_at_world6.bellatlantic.net>
- save the spreadsheet out to a comma separated file
- create a SQL*Loader control file (as per the doc)
- import the data into the DB table via SQL*Loader using the comma separated file and the control file
SQL*Loader will even create a "bad" file showing you the records it could not put into the table.
Ienaris wrote in message <6udrs1$rnc$1_at_newsie.singa.pore.net>...
>Hi...
>
>I've got an EXCEL 97 worksheet with all user names in the
>organization and I would like to import them into a USER
>table. Would appreciate any assistance as to how I could go about
>doing this. Any tools that are available in Oracle ??
>
>Pls mail to <valigean_at_post1.com>
>
>Thanx.
>
>
Received on Tue Sep 29 1998 - 04:17:10 CEST