topic Re: Import Access table into SAS in SAS Programming

Import Access table into SAS

wilman12 — Thu, 30 Mar 2023 16:23:01 GMT

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;

Re: Import Access table into SAS

Quentin — Thu, 30 Mar 2023 16:50:37 GMT

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 ;