Errors might occur when you import Microsoft Excel and Access files using the ExcelCS and the AccessCS drivers with the SAS® PC Files Server


With the second maintenance release for SAS® 9.2 Phase 2 (TS2M2) or later, when you import Microsoft Excel and Access file using the ExcelCS and AccessCS drivers with the SAS PC Files Server on X64 operating system, the following errors can occur:

  proc import dbms=excelcs
    out=work.test
    datafile="I:\LocalApp\Coles_SAS Documentation\NewBook.xls" replace;
    server="wpltyantst01";
    port=8621;
    sheet="Sheet1";
  run;

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Excel Driver] Your network access was interrupted. To continue, close the database, and then open it again.
ERROR: Error in the LIBNAME statement. Connection Failed. See log for details.

proc import dbms=excelcs
     out=yoursasdata datafile='c:\sastest\testpcserver3.xlsx' replace;
     port=8621;
     server='pebble03.trc.sas.com';
     sheet='mysheet';
run;

ERROR: Failed to connect to the Server: pebble03.trc.sas.com.

This happens if the drive is a network drive. The problem occurs on X64 systems where the SAS® System and the SAS PC Files Server both reside on the same machine. In such a case, the the new autostart feature is enabled. To resolve the problem, remove the SERVER= and PORT= options from your IMPORT and EXPORT procedures, as shown in this example:

 proc import dbms=excelcs out=yoursasdata 
             datafile='c:\sastest\testpcserver3.xlsx' replace; 
    sheet='mysheet'; 
 run;

For more information on the autostart feature, see PC Files Server Autostart, in SAS/ACCESS® 9.2 Interface to PC Files: Reference.