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

From: Juan Miranda <jmiranda_at_mundo-r.net>
Date: Mon, 29 Jan 2001 17:34:03 -0000
Message-ID: <9548vv$2pu1@cesio.mundo-r.com>

Export the data in Excel to a txt file.
Use SQL Loader to put the data into Oracle.

PC <prabhaweb_at_netscape.net> escribió en el mensaje de noticias 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 Mon Jan 29 2001 - 11:34:03 CST