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.