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.
Have you seen this?
Do you have the right 64-bit ACE components?
Have you seen this?
Do you have the right 64-bit ACE components?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.