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

From: JohnC <x_at_x.com>
Date: 1997/12/04
Message-ID: <666ugk$2on@mtinsc03.worldnet.att.net>#1/1

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
>

Well, if you want simple ASCII comma delimited data I don't know what is wrong with the select statements. YOu could go ODBC to an Excel speadsheet (or Access) and save as delimited maybe.. Received on Thu Dec 04 1997 - 00:00:00 CST