topic Problem with creating Excel library in Administration and Deployment

Problem with creating Excel library

Aman4SAS — Tue, 28 Jul 2015 07:20:47 GMT

Hi I m getting error while creating library using excel engine.

I am using SAS 9.3

my code

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.

Kindly suggest

Kurt_Bremser — Tue, 28 Jul 2015 07:44:37 GMT

Looks like the typical bitness problem. Try using the PC Files Server.

SASKiwi — Tue, 28 Jul 2015 08:23:59 GMT

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;

Aman4SAS — Tue, 28 Jul 2015 09:32:06 GMT

Priviously i was using 9.2 where simple i run my codes with using -libname xyz EXCEL "Path" now i m using 9.3 and getting error please suggest