Exporting the sas table in to accdb

[786786]

While exporting sas table in to accdb file i am facing with error that

FAILED TO CONNECT TO THE SERVER.

any solution over here?
thank you.



PROC EXPORT DATA=NAME
OUTTABLE="abcd"
DBMS=ACCESSCS
REPLACE;
DATABASE="DOCUMEMTS\ABC\ABCD.ACCDB";
DBDSPOTS="DBCOMMIT=0";
RUN;

[SASKiwi]

This option - DBMS=ACCESSCS - requires use of the SAS PC Files Server. Do you have that installed and running either on your own PC or on a remote Windows server accessible by you?

[786786]

Yes i have

[SASKiwi]

In that case if you are using a remote Windows server then you will need to specify the server name and port plus possibly your user name and password. You can read the doc here.

[jimbarbour]

First, I think make sure no one is editing the database. Probably not the issue, but worth checking -- and important to rule out.

The second thing I would try is switching from DBMS=ACCESSCS to just DBMS=ACCESS. Again, not necessarily the issue, but worth trying.

Jim