topic Re: Exporting the sas table in to accdb in SAS Programming

Exporting the sas table in to accdb

786786 — Thu, 05 Aug 2021 02:12:09 GMT

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;

Re: Exporting the sas table in to accdb

SASKiwi — Thu, 05 Aug 2021 02:18:58 GMT

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?

Re: Exporting the sas table in to accdb

786786 — Thu, 05 Aug 2021 02:21:31 GMT

Yes i have

Re: Exporting the sas table in to accdb

jimbarbour — Thu, 05 Aug 2021 02:37:34 GMT

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

Re: Exporting the sas table in to accdb

SASKiwi — Thu, 05 Aug 2021 03:19:01 GMT

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.