Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> can I export huge Excel file into SQL so I can run queires?

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

From: PC <prabhaweb_at_netscape.net>
Date: Thu, 25 Jan 2001 15:46:56 GMT
Message-ID: <3A6FEA03.88FAD9FE@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 - 09:46:56 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US