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

Home -> Community -> Usenet -> c.d.o.server -> Re: Importing Excel sheet data into ORacle8i

Re: Importing Excel sheet data into ORacle8i

From: Kenneth Koenraadt <plovmand_at_hotmail.com>
Date: Fri, 09 Mar 2001 18:42:30 GMT
Message-ID: <3aa923ed.213070@news.mobilixnet.dk>

Hi Sarma Venkata Subramanyam ,

I suggest you do the following:

  1. Export the Excel sheet content to a semicolon-separated text-file (Can be automated with an Excel Macro)
  2. FTP the text-file to the Solaris Host ( Can be automated with a .BAT file )
  3. Load the data into your DB using SQL*loader (Can be automated with a Shell-Script on the Host ).
    • Kenneth Koenraadt plovmand@<no-spam>hotmail.com
Received on Fri Mar 09 2001 - 12:42:30 CST

Original text of this message

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