Date: Thu, 23 Sep 2010 15:38:24 -0700
Reply-To: Dale McLerran <stringplayer_2@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Dale McLerran <stringplayer_2@YAHOO.COM>
Subject: Re: Problems reading Excel files
Content-Type: text/plain; charset=iso-8859-1
I don't know why, but for my installation, specification of a
libname with server= and port= specifications like the one
below does not work for me.
libname libref1 pcfiles server="server name" port=8621
For the server, I specified my computer's fully qualified name.
When I use the above syntax, I get the error message:
ERROR: CLI error trying to establish connection: [Microsoft][ODBC Excel
Driver] '(unknown)' is not a valid path. Make sure that the path
name is spelled correctly and that you are connected to the server
on which the file resides.
ERROR: Error in the LIBNAME statement.
What appears to be an explanation for this is found at:
But in my case, the SAS PC File Server service was started
after the network drives had been mapped.
Note, I have no trouble if I remove the server= and port=
specifications and simply enter
libname libref1 pcfiles path="drive:\path1\path2\file.xls";
Fred Hutchinson Cancer Research Center
Ph: (206) 667-2926
Fax: (206) 667-5977
--- On Thu, 9/23/10, Choate, Paul@DDS <Paul.Choate@DDS.CA.GOV> wrote:
> From: Choate, Paul@DDS <Paul.Choate@DDS.CA.GOV>
> Subject: Re: Problems reading Excel files
> To: SAS-L@LISTSERV.UGA.EDU
> Date: Thursday, September 23, 2010, 2:49 PM
> From what I have read, the ACCESSCS
> and EXCELCS engines are Access and Excel specific versions
> of the 64 bit PCFiles engine.
> So Dan's code below could also be written:
> libname libref1 pcfiles server="server name" port=8621
> or for Access
> libname libref2 pcfiles server="server name" port=8621
> Paul Choate
> Try something like the following
> libname BL_WH excelcs
> path="Q:\SBERESFO\PACE\Data\Baseline\Intensive Assessment
> H_W_C 013008.xls"
> server='your computer name'
> This syntax works on my system (similar to what you
> described). I just used the computer name that
> displays when I display the properties of my computer.
> Hope this is helpful,
> Daniel J. Nordlund
> Washington State Department of Social and Health Services
> Planning, Performance, and Accountability
> Research and Data Analysis Division
> Olympia, WA 98504-5204