Date:         Wed, 20 Feb 2008 09:50:13 -0500
Reply-To:     SUBSCRIBE SAS-L Tom Smith <tomquin99@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SUBSCRIBE SAS-L Tom Smith <tomquin99@GMAIL.COM>
Subject:      Re: Error with Proc IMPORT: File _IMEX_.'Sheet1$'n.DATA does not
              exist

-----------SAS log begins
11   proc import datafile = 'C:\temp\res.xls' dbms = excel2000 out =
lbn.dsn replace;
12   getnames=yes;
13   run;

ERROR: File _IMEX_.'Sheet1$'n.DATA does not exist.
ERROR: Import unsuccessful.  See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.46 seconds
      cpu time            0.12 seconds
-----------SAS log end

The tag Sheet1 does exist, and I also renamed it and tried different
names, and Save As the Excel file to different versions, all of which do
not help. I think the reason may be the number of columns >256.

I had this kind of problem when using PROC Export to convert dataset to
Excel file, then I used PROC DBLOAD to get the job done. Is there any proc
works in opposite direction to PROC DBLOAD ?