Importing access table in SAS

sasenthusiast07 — Wed, 04 Aug 2021 13:23:49 GMT

Good morning all,

I have read and write access to the MS AccessDB cause I created an table - I am trying to import the table into sas

Code:

proc import

datatable="b:\mydb\QualityC\Poplycarbine data inputs.accdb"

table='tbl001_PCRD'

out=PCRD

DBMS=Access

replace;

run;

Error says ---Unable to open the file

where am I going wrong?

Re: Importing access table in SAS

jimbarbour — Wed, 04 Aug 2021 17:19:42 GMT

The first thing I would check is: Is the file open? If the file is open and in use by another user, SAS may not be able to read it. This is certainly the default behavior for SAS with Excel, so I assume this is also true with Access.

Jim

topic Re: Importing access table in SAS in SAS Programming

Importing access table in SAS

Re: Importing access table in SAS