topic Re: Error importing xlsx file in Microsoft Integration with SAS

Error importing xlsx file

Enomis — Wed, 19 Dec 2018 10:56:20 GMT

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

Re: Error importing xlsx file

Kurt_Bremser — Wed, 19 Dec 2018 10:59:25 GMT

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

Run proc product_status and proc setinit.

Re: Error importing xlsx file

Enomis — Wed, 19 Dec 2018 11:07:41 GMT

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

Re: Error importing xlsx file

RW9 — Wed, 19 Dec 2018 11:12:12 GMT

Check out the user manual:

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

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

Try that.

Re: Error importing xlsx file

Kurt_Bremser — Wed, 19 Dec 2018 11:19:06 GMT

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

Re: Error importing xlsx file

Enomis — Wed, 19 Dec 2018 11:21:39 GMT

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.

Re: Error importing xlsx file

Kurt_Bremser — Wed, 19 Dec 2018 11:27:13 GMT

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).