Data import from Access 2013 to SAS 9.3

[mlogan]

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;

OUT=Apple.MyDATA1

DATATABLE='details';

DATABASE="E:\SAS\MyTable.accdb";

RUN;3

I get the following error:

ERROR: Failed to connect to the Server

[Kurt_Bremser]

I think your error message does not appear in the log, but as a pop-up from Enterprise Guide. Am I correct?

[mlogan]

Hi KurtBremser,

It appears in the log. I still have that problem, plz let me know if you can help.

Thanks,

[M_Maldonado]

Logan,

Enterprise Guide supports importing access databases. Have you tried to do File->Import Data?

Also give it a try posting your question on Data Management and Base SAS procedures communities.

Good luck!

-M

[Kurt_Bremser]

Then this should help you:

[SASKiwi]

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.