topic Re: PROC EXPORT to Access - SAS 9.4 connection failed in New SAS User

PROC EXPORT to Access - SAS 9.4 connection failed

vchao — Thu, 25 Apr 2019 19:42:13 GMT

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!

Re: PROC EXPORT to Access - SAS 9.4 connection failed

SASKiwi — Thu, 25 Apr 2019 20:08:07 GMT

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.

Re: PROC EXPORT to Access - SAS 9.4 connection failed

vchao — Mon, 29 Apr 2019 15:59:51 GMT

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!

Re: PROC EXPORT to Access - SAS 9.4 connection failed

TrueNorthLLC — Thu, 20 Oct 2022 15:30:18 GMT

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.