Date:         Thu, 9 Jan 1997 05:44:32 GMT
Reply-To:     DUFORFUN <duforfun@AOL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         DUFORFUN <duforfun@AOL.COM>
Organization: AOL http://www.aol.com
Subject:      PROC ACCESS

proc access dbms=xls;
create work.mytest.access;
path='c:\workset\myexcel.xls';
getnames=y;
worksheet=sheet2;
list;
run;
 
After I hit F3 key, I got error message. Then I deleted  "
WORKSHEET=SHEETn" (where n=2,3,....16). Re-run the PROC again, it works. I
don't know why. Please help me. By the way, myexcel.xls is Excel 5 file
and I am working with SAS 6.11 for WIN-NT3.51.
 
E-Mail address:
DUFORFUN@AOL.COM