How to import access file

Naveen1111 — Sun, 06 Sep 2020 17:23:00 GMT

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

Re: How to import access file

Kurt_Bremser — Sun, 06 Sep 2020 17:55:38 GMT

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

See here.

topic Re: How to import access file in New SAS User

How to import access file

Re: How to import access file