How to import access file

[Naveen1111]

Hi All,

can anyone tell me why I m getting this error while importing access file.

proc import
out=vinay
table=flight
dbms=accesscs
replace;
database="C:\Users\abc\Desktop\ak.mdb";
run;

output

proc import
2 out=vinay
3 table=flight
4 dbms=accesscs
5 replace;
6 database="C:\Users\abc\Desktop\appu.mdb";
7 run;

ERROR: Failed to connect to the Server: .
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.00 seconds
cpu time 0.09 seconds

[Kurt_Bremser]

When you use the ACCESSCS engine, you need to supply the name of the host where the PC Files Server runs.

See here.