07-28-2015 03:20 AM
Hi I m getting error while creating library using excel engine.
I am using SAS 9.3
libname abc Excel "c:\anuj\test.xls";
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
i have install both file from link:
problem still has not been resolved.
07-28-2015 03:44 AM
Looks like the typical bitness problem. Try using the PC Files Server.
07-28-2015 04:23 AM
While you have installed the PC File Server you are not using the correct LIBNAME to use it as described in this link:
For example: libname test pcfiles path='drive:\yourdirectory\yourfile.xls' server='yourserver' port=9621;