topic Re: Not able to Import MS Access .accdb or .mdb in Base 9.4 Do I need to Know my Server? in Microsoft Integration with SAS

Not able to Import MS Access .accdb or .mdb in Base 9.4 Do I need to Know my Server?

rbikes — Fri, 20 Mar 2015 21:42:27 GMT

So my project has me starting off with importing MS Access files, but the thing is I'm not able to do that. While I have ran this code below to tell me if I have SAS/ACCESS engine. :

PROC SETINIT;

RUN;

it tells me I do until for orcle, PC files, and ODBC.

I just can't run this code:

%let name="Path\location\AccessFileName";

option symbolgen;

proc import DBMS=ACCESSCS

table="table1"

OUT = tableout1

REPLACE;

DATABASE=&name;

RUN;

But This code bellow works

proc import datafile="Path\location\TableFileName"

OUT=tableout2

DBMS=xls

REPLACE;

getnames=yes;

RUN;

64 bit system, 64 bit SAS platform, 64 bit MS office suite. No idea what is happening.

Is my issue not specificity my server, and if that is the case how do I find what my server name is?

I've read this 33228 - An error occurs when you use SAS® 9.2 to import or export Microsoft Excel or Access files in the Windows x64 and Windows Vista 64-bit environments

but can't tell how to find my server...

Re: Not able to Import MS Access .accdb or .mdb in Base 9.4 Do I need to Know my Server?

ballardw — Fri, 20 Mar 2015 21:52:40 GMT

You used DATABASE in the first example not DATAFILE. Also the ; before DATABASE ended the Proc Import statement early.

Re: Not able to Import MS Access .accdb or .mdb in Base 9.4 Do I need to Know my Server?

Reeza — Fri, 20 Mar 2015 22:06:43 GMT

Have you tried doing it via the point and click import and saving the code?

If it doesn't work, it helps if you post the log as well.

Re: Not able to Import MS Access .accdb or .mdb in Base 9.4 Do I need to Know my Server?

rbikes — Mon, 23 Mar 2015 17:17:09 GMT

You would be correct if for that part of code I was trying to import an excel file, but I was trying to open the MS access file.

Re: Not able to Import MS Access .accdb or .mdb in Base 9.4 Do I need to Know my Server?

rbikes — Mon, 23 Mar 2015 17:23:05 GMT

Here is the error for the point and click.

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement.

Now using the libname:

libname mdb pcfiles path="test.mdb";

I get this error:

ERROR: Unable to locate pcfserver.exe. Please install PC Files Server.

ERROR: Error in the LIBNAME statement.

Which is so weird to me becase when I run this code it shows that I have PC Files and accessing excel files works just fine....:

---SAS/ACCESS Interface to PC Files

Re: Not able to Import MS Access .accdb or .mdb in Base 9.4 Do I need to Know my Server?

rbikes — Mon, 23 Mar 2015 17:59:14 GMT

It turns out I am running a 32 bit MS Office, sorry about the missup and found this link.

38779 - The 64-bit edition of SAS/ACCESS® 9.2 Interface to ODBC running in a 64-bit Windows operating environment requires 64-bit ODBC drivers

Is there any update to this, or do we still need to use older SAS programs?

Re: Not able to Import MS Access .accdb or .mdb in Base 9.4 Do I need to Know my Server?

rbikes — Mon, 23 Mar 2015 18:20:28 GMT

I found a potential solution, here.

SAS Downloads: SAS PC Files Server