topic ERROR: The EXCEL engine cannot be found. in Microsoft Integration with SAS

ERROR: The EXCEL engine cannot be found.

Kfhansen — Wed, 21 Apr 2010 21:24:30 GMT

As the subject implies I have an issue where I get this error when I submit the following:

libname flowdata excel "C:\exceldata\Reports\Flows.xls";

ERROR: The EXCEL engine cannot be found.
ERROR: Error in the LIBNAME statement.

EVENTHOUGH we do have the SAS/ACCESS PC File format license and it is current.

Anyone have any suggestions to what is wrong ? UPDATE:
Forgot to mention that we are running 9.1.3

Message was edited by: Kfhansen

Re: ERROR: The EXCEL engine cannot be found.

sbb — Wed, 21 Apr 2010 21:58:30 GMT

Can you share info about if/when the same type of code did in fact work on the same machine in the past? There is a distinct difference with having a SAS component licensed as compared to having the component installed on a particular machine. You can use PROC SETINIT to identify the installed product(s).

Scott Barry
SBBWorks, Inc.

Re: ERROR: The EXCEL engine cannot be found.

Kfhansen — Thu, 22 Apr 2010 12:31:07 GMT

Sure:

Expiration: 31JUL2010.
Grace Period: 45 days (ending 14SEP2010).
Warning Period: 45 days (ending 29OCT2010).
System birthday: 14OCT2009.
Operating System: WIN .
Product expiration dates:
---Base Product 31JUL2010
---SAS/STAT 31JUL2010
---SAS/GRAPH 31JUL2010
---SAS/FSP 31JUL2010
---SAS/AF 31JUL2010
---SAS/IML 31JUL2010
---SAS/SHARE 31JUL2010
---SAS/LAB 31JUL2010
---SAS/ASSIST 31JUL2010
---SAS/CONNECT 31JUL2010
---SAS/INSIGHT 31JUL2010
---SAS/EIS 31JUL2010
---SAS/SHARE*NET 31JUL2010
---SAS Enterprise Miner 31JUL2010
---MDDB Server common products 31JUL2010
---SAS Integration Technologies 31JUL2010
---SAS/ACCESS Interface to ORACLE 31JUL2010
---SAS/ACCESS Interface to PC Files 31JUL2010

I susspect that some files were not loaded onto my PC when the software was loaded but I don't know how to verify that.

UPDATE:
I just tested it on my laptop, that supposedly should have the same installation that my pc has, and here is works.

Message was edited by: Kfhansen UPDATE:
I figured it out.
It was as I suspected, for some reason not all the access dll's were loaded to my pc.
To solve the problem I copied the /SAS/SAS 9.1/access/sasexe folder from my Laptop to the same location on my PC and now it works.

Message was edited by: Kfhansen