Hi, This is an old question, but just posting incase if it may help someone. I had the same problem with SAS V9.3 (importing to SAS from Access database having accdb extension). For me, the trick was to incorporate the password which was linked to the Access database, as that will be needed if you want to import individual tables to SAS (DBPWD option below). I first used the SAS interface to import individual access individual tables (have only a few i.e 7 tables) and the below is the SAS syntax file that was produced (imported succesfully to SAS): Libname fin "D:\study"; /*libname where you will store your SAS data for Table1*/ PROC IMPORT OUT= fin.table1 DATATABLE="Table One" DBMS=ACCESS REPLACE; /* name of the particular table you want to import from Access database*/ DATABASE="D:\Study\accessdatabase.accdb"; /* location and name of the Access database*/ DBPWD="accessdatabasepassword"; /* the access database password, that you use to open the access database, if exists*/ SCANMEMO=YES;USEDATE=NO; SCANTIME=YES; RUN;
... View more