Hi Chris,
I'm hoping you can help me despite how old this blog post is!
I have a 64 bit SAS, 64 bit Windows, and 64 bit Office 2016. I for some reason cannot (either with the import wizard or code) import an excel data file.
I get the error "ERROR: Failed to connect to the Server"

Here is my code:
LIBNAME PCFILES PATH='C:\Users\lsalt\OneDrive\Documents\School\HLTH 5150';
PROC IMPORT OUT= Bodyfat
DATAFILE= "C:\Users\lsalt\OneDrive\Documents\School\HLTH 5150\Large.Bodyfat.xlsx"
DBMS=EXCELCS REPLACE;
RUN;
I have also tried many other proc import code variations, once I get the code right, I get the exact same "Failed to connect to the server error".
I have double checked that all my software is the 64-bit version, so now I am unsure what I can do. I have tried various DBMS=xxx options (EXCEL, XLSX, EXCELCS).
Any help would be much appreciated!