Date: Mon, 31 Mar 2008 10:33:21 -0700
Reply-To: Aldo <acrossa@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Aldo <acrossa@GMAIL.COM>
Subject: Proc Import Error
Content-Type: text/plain; charset=ISO-8859-1
I have a large Excel 2003 file that I'm tryin to import into SAS 9.0
but I'm getting this error message:
2 proc import out = data
3 datafile = "D:\MyDocs\databade.xls"
4 dbms = EXCEL2000 replace;
5 sheet = "Sheet$";
6 getnames = yes;
ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.28 seconds
cpu time 0.04 seconds
But I really have no idea what the problem is (since the log details
are not very detailed!). This started happening when I updated from
Windows 2000 to XP, and from Office 2000 to 2003. I'm assuming it has
to do with that, but have found nothing useful on the internet.