Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Extra Empty Record

Extra Empty Record

From: Mitch <mitchell7468_at_my-deja.com>
Date: Wed, 15 Dec 1999 20:51:19 GMT
Message-ID: <838v05$j88$1@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 Wed Dec 15 1999 - 14:51:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US