Re: Excel to Orcale

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Thu, 5 Oct 2000 20:20:06 GMT
Message-ID: <39DCE276.66FCAB17@edcmail.cr.usgs.gov>

You can dump the excel spreadsheet to a comma delimited or fixed width text file. Then use SQL*Loader to load the data. Refer to the Oracle Utilities Guide for more information on SQL*Loader.

HTH,
Brian

Yogesh wrote:
>
> Dear Sir,
>
> I have the data already written in excel sheet. In following manner
>
> 200 43013221000002 100000001 00 000001 000003 G U
> 200 43013221000002 100000001 00 000001 000003 C U
> 00
>
> I have to dump it to oracle 7.x
>
> How can I achieve this . Please Help me in this regard
>
> Thanx
>
> --
> Posted via CNET Help.com
> http://www.help.com/

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Thu Oct 05 2000 - 15:20:06 CDT