How to import password protected MS Access tables to SAS

[Anita_n]

Hello all,

I wish to import some tables from an Access DB which is password protected and am encountering some problems. Maybe someone can help:

I get the following error message when I run the code below:

ERROR: CLI error trying to establish connection: [Microsoft] [ODBC driver for Microsoft Access] General error The registry key 'Temporary (volatile) Ace DSN for process 0x273c Thread 0x1814 DBC 0x7f82b4
   Jet 'cannot be opened..
ERROR: Error in the LIBNAME statement.
ERROR: Connection Failed.  See log for details.

proc import out= lib.myoutdat
           datatable= "patient" 
           dbms=accesscs replace;
     database= "mypath.\mydb"; 
     scanmemo=yes;
     usedate=no;
     scantime=yes;
	dbpwd='&mypassword';
	 run;

[SASKiwi · Accepted solution]

Your password macro variable won't resolve inside single quotes. Try double quotes:

proc import out= lib.myoutdat
           datatable= "patient" 
           dbms=accesscs replace;
     database= "mypath.\mydb"; 
     scanmemo=yes;
     usedate=no;
     scantime=yes;
	dbpwd="&mypassword";
	 run;