From: "H. John C. Hopkins" <john@hpe.ufl.edu>
Subject: Re: How can I upload dumped data from SQL server to Oracle server
Date: 1997/08/08
Message-ID: <01bca412$cca281e0$d335e380@john.hpe.ufl.edu>#1/1
References: <33D8EBA4.BE09449B@cs.wmich.edu> <01bc9d74$8da1ce50$725118d2@sin00119>
Organization: Shands Hospital
Newsgroups: comp.databases.oracle.misc



Provided you don't have more rows than Excel can handle.

Just a caution.

-John



N Prabhakar <n_prabhakar@post1.com> wrote in article
<01bc9d74$8da1ce50$725118d2@sin00119>...
> You can try the following.
> 
> 1. Open the SQL server data, save it in EXCEL as comma delimited file
> (.CSV)
> 2. Using SQL*Loader utility, you can read the comma delimited file and
 load
> the data into the Oracle database.
> 
> Regards
> 
> N.Prabhakar
>