Date:         Mon, 8 Feb 1999 23:42:53 -0500
Reply-To:     Hai-Bin Shu <hshu@STAT.PURDUE.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Hai-Bin Shu <hshu@STAT.PURDUE.EDU>
Organization: Purdue University
Subject:      Re: PROC DBLOAD with EXCEL
In-Reply-To:  <Pine.HPP.3.91.990208184407.19461B-100000@fhs.csu.McMaster.CA>
Content-Type: TEXT/PLAIN; charset=US-ASCII

The naming convention follows that under DOS.
 
hshu@stat.purdue.edu
 
 
On Mon, 8 Feb 1999, Christopher Sigouin wrote:
 
> HI I'm having trouble with deleting an excel file with 6.12 windows 95.
>
> I realize the existing file must first be deleted before it can be
> created again.
>
> The program will create the test.xls file the first time the program is
> run but will not delete the file when I run the program again.
>
> Here is the code:
>
> options noxwait;
> x 'del c:\my documents\public health\test.xls';
>
> proc dbload dmbs=excel data=qual;
> path='c:\my documents\public health\test.xls';
> load;
> run;
>
> The above program works when the directory has no blanks in it, that is,
> c:\temp\test.xls  INSTEAD OF c:\my documents\public health\test.xls
>
> Is there some way of accessing a directory with the spaces in it??
>
> Thanks,
> Chris
>
>