Pankaj_Jha wrote:
> Hello world,
>
> can some one tell me how to Copy lakhs of Records in a table of 25
> columns from text file or Excel Sheet in one go.
>
> Pls. provide an example
>
>
> Thanks
>
> Pankaj
>

With Excel, you can save the data as a comma-separated values format
(CSV). Once in CSV format, you can use SQL*Loader or External Tables to
load the data into an Oracle table. There are many options at play, so
your specific environment and requirements may dictate which options you
use. Please read the Oracle Utilities guide paying attention to the
chapters on SQL*Loader and External Tables:

http://download-east.oracle.com/docs...b14215/toc.htm


HTH,
Brian

--
================================================== =================

Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown