Re: Export data from Oracle to another SQL server ???

Hi Peder,

I have developed a small but powerful utility with which you can solve your problem. It allows you to query Oracle and paste the values into an excel spreadsheet. In Excel you can save that data into a comma delimited file.

My tool is called Oraxcel and is very user friendly. When installed or just opened it appears as a new menu item called Oracle. Simply logon to your Oracle DB and put the query in and there you go....

Please have a look at he Oraxcel homepage at: http://members.aol.com/gjlinker/projects/oraxcel

There are screenprints available on that page.

Kind regards, Gerrit-Jan Linker

In article ,
  Brian Hall wrote:
>
> On a related subject:
> I am trying to export data from an Oracle DB for other reasons, and all I need
> is ASCII fixed or delimited. It seems that the EXP & SQLLoader products do
> Oracle specific formatting which I don't want. Is there a better way to do
> this without having to get a 3rd party product. I'd rather do this without
> having to spool SELECT statements or buying more software.
>
> Thanks in advance,
> Brian Hall
>
> Peder Holst wrote:
>
> > Sergei,
> > For the migration or replication of data between the two - check and
> > download
> > SQLMover from http://www.sqlmover.com. It handles Oracle LONG, SQL Server
> > Text, Image and Binary datatypes. Use the Intersolv ODBC driver for Oracle
> > and the full evaluation key 1KKJBFJYF for SQLMover.
> > Peder Holst
> > pederh_at_elektrosoft.se
> >
> > Sergei Didur wrote in article
> > ...
> > > Hi everybody !
> > >
> > > I'd like to unload data from Oracle DB and then load it to Sybase.
> > > I'm looking for something like Sybase BCP utility for Oracle.
> > >
> > > Thanks in advance,
> > > Sergei Didur
> > >

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet