Thanks. Using http://www.codeproject.com/Questions/553016/Microsoft-ACE-OLEDB-plus-pluswhereplusisplusit as a reference, I searched C:\Program Files for ACEOLEDB.DLL and didn't find it and searched C:\Program Files (x86) for ACEOLEDB.DLL and found it. So it looks like only the 32-bit ACE driver is installed, not the 64-bit one.
I tried the following libname statement
libname testacdb "D:\Data\test.accdb" ;
and got the following error:
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
I tried the following PROC IMPORT code
PROC IMPORT OUT=WORK.AB_CAT_adj
DATATABLE='AB_CAT_adj'
DBMS=ACCESSCS REPLACE;
DATABASE="D:\Data\test.accdb";
USEDATE=YES;
SCANTIME=NO;
DBSASLABEL=NONE;
RUN;
and got the following error
ERROR: Failed to connect to the Server: .
I have more SAS products installed on my PC than the target user; one of those products is the PC Files Server. So I tried the following code (but with the real domain in realdomainhere) with the same Access database on my PC's C: drive:
%macro import_table () ;
%local client_machine ;
%let client_machine = %sysfunc(dequote(&_CLIENTMACHINE.)).realdomainhere.COM ;
PROC IMPORT OUT=KEVIN.AB_CAT_adj_5pct
DATATABLE='AB_CAT_adj_5pct'
DBMS=ACCESSCS REPLACE;
DATABASE="C:\test.accdb";
SERVER="&client_machine";
PORT=9621;
DBDSOPTS='READBUFF=300';
RUN;
%mend import_table ;
%import_table ;
and that worked. However, if I tried it a second time, it didn't work and I had to restart my computer to get it to work again. I have asked a user who only installed EG and the SAS Add-In for Excel to install the appropriate PC Files Server version based on the version of SAS on the server and then try that code a few times in case it only works once without rebooting.
... View more