Importing access table in SAS

[sasenthusiast07]

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?

[jimbarbour]

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