Error importing xlsx file

[Enomis]

Hi,
when I try to import an Excel file I get the error:

 PROC IMPORT datafile="C:\temp\test.xlsx"
 OUT=test
 DBMS=EXCEL REPLACE;
 RUN;

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

SAS:  9.4  64bit
Office: 2016 32bit

PC file server: already installed

Have you got any advice?

Thanks
Simone

[Kurt_Bremser]

ACCESS to PC Files is not installed and/or not licensed.

Run proc product_status and proc setinit.

[Enomis]

Hi,
in the setinit log I've the line:

---SAS/ACCESS Interface to PC Files

If I look at the Windows Services, PC File Server is running.

I've another machine with the same configuration, when i Run the proc import I don't get any error.

That's very strange

[RW9]

Check out the user manual:

http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#p0jf3o1i67m044n1j0...

If you are using libname to excel then it is excel, otherwise in proc import it should be xlsx.

Try that.

[Enomis]

I have hundreds of program importing Excel files (using the proc import above), different user run them on different machine.

I've this kind of problem with just one PC.

[Kurt_Bremser · Accepted solution]

If you have local SAS installations, then the installation on that PC is defective or has a different license/productstatus.

I would STRONGLY recommend to get rid of the local installations and switch to a central SAS server. Usually reduces license costs, but is guaranteed to reduce administrative cost (see your current issue).

[Kurt_Bremser]

Using the PC Files Server requires dbms=excelcs and supplying the server name.