How to import password protected MS Access tables to SAS

Anita_n — Wed, 10 Mar 2021 13:13:33 GMT

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;

Re: How to import password protected MS Access tables to SAS

SASKiwi — Wed, 10 Mar 2021 19:19:40 GMT

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;

topic How to import password protected MS Access tables to SAS in SAS Programming

How to import password protected MS Access tables to SAS

Re: How to import password protected MS Access tables to SAS