DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Learner
Posts: 1
Accepted Solution

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

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.

 


Accepted Solutions
Solution
‎03-16-2018 09:40 AM
Super User
Posts: 2,512

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

[ Edited ]
Posted in reply to Chriscee99

Have you seen this?

Do you have the right 64-bit ACE components?

View solution in original post


All Replies
Solution
‎03-16-2018 09:40 AM
Super User
Posts: 2,512

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

[ Edited ]
Posted in reply to Chriscee99

Have you seen this?

Do you have the right 64-bit ACE components?

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 121 views
  • 0 likes
  • 2 in conversation