Re: can I export huge Excel file into SQL so I can run queires?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 25 Jan 2001 16:15:08 -0000
Message-ID: <94pjei$c2k$1@soap.pipex.net>

sql loader is you friend for this task

you need a control file something like

infile '<csvfilename>'
badfile '<badfilename>'
discardfile '<discardname>'
logfile '<logfilename>'
field seperated by ','
optionally enclosed by '"'
append into <tablename>
(col1,col2,col3)

this assumes you save the file from xl as a comma seperated file.

you then need to precreate the table and just do the load. See the oracle utilities reference for sql*loader examples.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"PC" <prabhaweb_at_netscape.net> wrote in message
news:3A6FEA03.88FAD9FE_at_netscape.net...


> 1) Is there a way to bring a big Excel file into SQL?

>

> 2) I also have this big file in ASCII format. Can I bring this into SQL?

>

> 3) Both types of file are just raw data -- 3 columns of figures, but no

> heading etc.

> How can I make tables out of these columns? Do I create a script with

> "inserts"?

> I have about 2000 records. So will my script have 2000 inserts?????

>

>

> thanks so much,

>

>

Received on Thu Jan 25 2001 - 10:15:08 CST