PROC EXPORT to Access - SAS 9.4 connection failed

[vchao]

I recently upgraded my laptop to Windows 10 and installed SAS 9.4. 

Below is a procedure I frequently used when I had SAS 9.3 before to export a dataset to Access.  Since I got my new laptop which has Windows 10 and SAS 9.4, I have been having trouble running this.  I kept getting this message, "

ERROR: Connection Failed. See log for details." 

PROC EXPORT DATA = APPNDRANK

DBMS = ACCESS REPLACE

OUTTABLE = "ELIGRANK";

DATABASE = "C:\Vickie_SAS\BOOM_ELIGRANK.MDB";

RUN;

I did some research - tried to changed it to ACCESSCS, but still got the same error message.  Could you please help?  Thanks!

[SASKiwi]

Is your SAS 9.4 32-bit or 64-bit and your MS Office 32-bit or 64-bit? The bitness has to match between the two.

If it doesn't match you could always download the MS JET Engine components of the right bitness from Microsoft site. It's a free download.

[vchao]

Hi, I went back and checked the configuration of SAS and MS Office.  The bit was off, indeed.  I had the issue rectified - now both SAS and MS Office are in 64-bit.  But the problem is still there.  I get the same error message.  Help!

[TrueNorthLLC]

I realize this is old, but I recently ran into this again and forgot how I had fixed it last time. The Access component that installs with SAS 9.4 seems like it is mismatched, so you need to uninstall it and then install the correct bit version from here:

https://www.microsoft.com/en-us/download/confirmation.aspx?id=39358

at least that fixed it for me.