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>
Organization: http://groups.google.com
Subject:      Proc Import Error
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Dear all,

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;
7    run;

ERROR: Connect:
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.

Any ideas??

thanks!

Aldo Crossa