• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 746
  • Last Modified:

SAS EXCEL Import Error - HHHEEEELLLP!!

Hi,
I am getting an error message importing an EXCEL file into SAS v9.1.  It comes back with "Connection Failed - check log" and the log indicates has an irrelevant message.

I must admit I had 2 version of EXCEL on my PC at the same time.  I had EXCEL 2002 and a trail version of 2007.  The trail expired.  I uninstalled the 2007 trail and reinstalled EXCEL 2002.

It still does not work.  I'm not sure what ODBC settings are correct?

Any help would be greatly appreciated.

Thanks in advance.
hefterr
0
hefterr
Asked:
hefterr
  • 2
2 Solutions
 
bradanelsonCommented:
Can you provide the code used and the portion of the log that shows the error?

Thanks
0
 
Aloysius LowCommented:
how are you doing the import exactly?

do you have base SAS installed on your PC?

I'm not sure, but just thinking if a license is required for reading PC file format which you don't have. Quite hard to guess or help without a log.
0
 
hefterrAuthor Commented:
I found the answer so thanks.

It was an HP deskjet driver that I found is documneted to cause this problem.

Thanks anyway.
0
 
Aloysius LowCommented:
sounds totally unrelated and weird but glad your problem was resolved! :)
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now