Proc Export to Access

[xavpontes]

Please let me know the fix for this error message (please see attached file). Thank you.

[ballardw]

Can you verify that our PC Files Server is configured/working?

[xavpontes]

My PC Files Server was installed yesterday, 9/20/16. Thank you.

[ballardw]

Is the server local (running on your machine) or remote? If remote then you may be attempting to write to a location on the remote machine that either doesn't exist or you do not have permissions for.

You might investigate use of a LIBNAME statement for connection, especially if your data base already exists and you want to insert a new table. Proc Export tends to replace entire databases.

It would look something like:

LIBNAME mymdb PCFILES SERVER=D2323 PATH='c:\demo.mdb';

Then use like any other library:

Data mymdb.tablename;

    set sashelp.air;

run;

[xavpontes]

Thank you all. The issue was the PC Files Server and it has been fixed.
My tech support had to work with SAS Technical Support on this. All
replies were helpful. Thank you again. Much appreciated.