Import Access table into SAS

[wilman12]

I am trying to import a table in access into SAS, but am not having much luck. Here is the import statement I am using which does not work. I've also tried to use the import wizard but I keep getting the error message - OLEDB Connection Problem. Any inisights??

PROC IMPORT OUT=WORK.AcctMarketList
DATATABLE='tblAcctMarketList'
DBMS=ACCESS REPLACE;
database=".......Management\TABLES.mdb";
RUN;

[Quentin]

Your PROC IMPORT code looks good to me.

Can you please post the full error message?

What version of SAS are you running, and it looks like you're running on Windows?

What do you get in the log if you try to use a libname statement to connect, e.g.:

libname foo access "...Management\TABLES.mdb" ;
proc datasets library=foo ;
run ;