SAS Enterprise Guide error importing Excel from SharePoint

[iblock]

I am trying to import excel workbooks from a SharePoint folder using the Import Data option in SAS EG.  It has worked for several other files, but for 3 in particular I am getting the following error:

SAS Enterprise Guide has encountered a problem

We recommend that you save your work and restart SAS Enterprise Guide.

Object reference not set to an instance of an object.

Also, I did restart SAS EG and the error is still occurring for those 3 files.

[ChrisHemedinger]

Can you give an example of the type of path you're providing to the Import Data task? Is this an on-premise SharePoint with a mapped drive or \\network\path style of path?  

Chris

[iblock]

"C:\Users\XXXX\XXXX\SharePoint Folder\Filename.xlsm"

[ChrisHemedinger]

Are you using 64-bit SAS Enterprise Guide? If so, you might need the 64-bit version of the Microsoft data access tools.  The components that EG uses to read these proprietary XLSM files are basically part of the operating system, but the bitness (32-bit or 64-bit) usually matches that of the Microsoft Office you have installed.  If using 32-bit Office and 64-bit EG, this presents an incompatibility problem.

Or, if possible, get a version of the Excel file that isn't macro-enabled (XLSM), like XLSX.  EG can read those directly.

[Reeza]

Does anyone have those files checked out?