Import Access DB file form Local drive

[anilgvdbm]

Dear All,

I have a file with .accdb format in my local drive and i want to import that into SAS. Please help me in this issue.

Regards,

Anil

[Kurt_Bremser]

Is SAS installed locally or remotely on a server?

Do you use Enterprise Guide, SAS Studio, or Display Manager as frontend?

[anilgvdbm]

SAS installed remotely and the accdb file also there in that sas server.

I need to convert that accdb file into sas7bdat file for my further analysis.

Regards,

Anil

[Kurt_Bremser]

The server has to be running on Windows, and you need SAS/ACCESS to PC Files licensed and installed.

proc import dbms=access or libname access should work (you might need to have MS ACE installed).

If your server runs on a non-Windows system, you need to set up the SAS PC Files Server on a Windows computer where the accdb files are accessible, and use dbms=accesscs.

[anilgvdbm]

Yes SAS/Access PC files are installed and but I'm getting an error like failed to connect to server

Please suggest me if you have any reference code or file.

[Kurt_Bremser]

See the documentation. The code would likely be

proc import
  datafile="\path\file.accdb"
  table="name_of_table"
  out=mylib.mydata
  dbms=access
  replace
;
run;