Issues importing database to Sas 9.4 x64 from Access (x64) libname error

Chriscee99 — Thu, 15 Mar 2018 23:58:56 GMT

I am having an issue when trying to assign a libname or import access files. I have reviewed a number of threads and unfortunately none of them have helped. I have the same bitnes (64-bit) for SAS 9.4 and Access, and have PCFiles installed. Below are the codes i used and error messages I received:

214 proc import
215 datafile= "filepath.accdb"
216 out= work.sasfile
217 replace dbms=access;
218 run;

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
ERROR: Connection Failed. See log for details.

225 LIBNAME in "filepath.accdb";

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.

Re: Issues importing database to Sas 9.4 x64 from Access (x64) libname error

ChrisNZ — Fri, 16 Mar 2018 00:40:00 GMT

Have you seen this?

Do you have the right 64-bit ACE components?

topic Issues importing database to Sas 9.4 x64 from Access (x64) libname error in SAS Programming

Issues importing database to Sas 9.4 x64 from Access (x64) libname error

Re: Issues importing database to Sas 9.4 x64 from Access (x64) libname error