Re: Extra Empty Record

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 16 Dec 1999 20:52:08 -0000
Message-ID: <945378809.15497.0.nnrp-01.9e984b29@news.demon.co.uk>

Try adding:

    btitle off
    ttitle off
    set embedded on

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Alan Shein wrote in message <83b51j$bdp$1_at_bob.news.rcn.net>...
>Just edit the spool file.
>
>Mitch <mitchell7468_at_my-deja.com> wrote in message
>news:838v05$j88$1_at_nnrp1.deja.com...
>> The following psuedo-query seems to put an extra empty record into the
>> text file it spools to. Thus, when I import the text file into MS
>> Access I get an import error when I import with a primary key defined.
>> I'd appreciate it if someone could let me know how I could get rid of
>> the extra record.
>>
>> SPOOL C:\Sample.txt
>> SET NEWPAGE 0
>> SET SPACE 0
>> SET LINESIZE 150
>> SET PAGESIZE 0
>> SET COLSEP |
>> SET ECHO OFF
>> SET FEEDBACK OFF
>>
>> Select ?????????
>> From ?????????
>> Where ?????????
>>
>> SPOOL OFF
>>
>> Thanks Much
>>
>> Paul
>>
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>
>
Received on Thu Dec 16 1999 - 14:52:08 CST