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

You will need to save the Excel file as CSV.

On Thu, 25 Jan 2001 16:15:08 -0000, "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:

>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,
>>
>>
>
>

EMail: knijff_at_bigfoot.com Received on Sat Jan 27 2001 - 03:45:07 CST