Usage Note 37479: Errors can 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.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.18 seconds
cpu time 0.01 seconds
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.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.21_M2 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.21_M2 | 9.2 TS2M2 | ||||
| Microsoft® Windows® for x64 | 9.21_M2 | 9.2 TS2M2 | ||||
| Microsoft Windows XP 64-bit Edition | 9.21_M2 | 9.2 TS2M2 | ||||
When you use the ExcelCS and AccessCS drivers on the same machine where the SAS PC Files Server is installed as a service, the PC Files Server autostart feature is automatically used. In such cases, do not specify values for the PORT= and SERVER= options in PROC IMPORT or PROC EXPORT statements.
| Type: | Usage Note |
| Priority: | |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> MS Access Data Management ==> Data Sources ==> External Databases ==> MS Excel |
| Date Modified: | 2009-10-20 08:13:34 |
| Date Created: | 2009-10-15 11:04:48 |