excel libname not working - SAS Support Communities

Calcite | Level 5

Calcite | Level 5

excel libname not working

Posted 07-24-2015 06:51 AM (1184 views)

Hi,

I am trying to import an excel sheet with libname statement

Libname dataex EXCEL "Z:\data.xls";

this gives an error.

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement

I have updated the PCfiles server also.

I use 64bit windows and 32bit office.

1 REPLY 1

Diamond | Level 26

Diamond | Level 26

Re: excel libname not working

Posted 07-24-2015 08:05 AM (1164 views) | In reply to anan

A quick Google search reveals:

37412 - Errors occur when you import Microsoft Excel or Microsoft Access files into SAS® 9.2

April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!