Re: Help with SQL+
From: BobH <b-horton_at_worldnet.att.net>
Date: 1998/04/19
Message-ID: <6hebsr$9fc_at_bgtnsc02.worldnet.att.net>#1/1
Date: 1998/04/19
Message-ID: <6hebsr$9fc_at_bgtnsc02.worldnet.att.net>#1/1
S Zandi wrote:
>
> Hi all,
> I would be grateful if someone could help me out with the following:
> As a novice user of SQL+, I need to do a query which involves 20+
> columns and thousands of rows (from an Oracle table). I would like to
>
> save the result and open it in, say MS Excel. Spooling it and then
> opening it in Excel does do the trick. How do I go about this? I've
> played with this but the data does not stream in cleanly as rows and
> columns.
> Am I up the wrong tree and cannot do this and need to go onto ODBC?
> Regards.
>
I suggest that with linesize, pagesize settings that you delimit
your columns data with 'hard tabs'. Expecially in to got into EXCEL.
Received on Sun Apr 19 1998 - 00:00:00 CEST