05-19-2015 04:52 PM
I am trying to import data from Access 2013 to SAS 9.3 with the following code. Can anyone tell me what is the mistake I am doing?
PROC IMPORT DBMS=ACCESSCS replace;
I get the following error:
ERROR: Failed to connect to the Server
05-20-2015 01:31 AM
I think your error message does not appear in the log, but as a pop-up from Enterprise Guide. Am I correct?
05-20-2015 03:27 PM
05-21-2015 01:23 AM
Then this should help you:
05-20-2015 03:43 PM
DBMS=ACCESSCS requires that you have the SAS PC File Server installed and operating on either your PC or on a remote server you have access to - this could be your SAS server. The usual reason for using this is to deal with 64-bit versus 32-bit incompatibilities. The error you got indicated it couldn't connect to the SAS PC File Server.
You could also try DBMS = ACCESS. This method doesn't require the SAS PC File Server but if your SAS server is 64-bit it would need to have 64-bit MS Office components installed.