topic SAS Enterprise Guide error importing Excel from SharePoint in SAS Enterprise Guide

SAS Enterprise Guide error importing Excel from SharePoint

iblock — Tue, 22 Oct 2019 18:53:10 GMT

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.

Re: SAS Enterprise Guide error importing Excel from SharePoint

ChrisHemedinger — Tue, 22 Oct 2019 18:54:38 GMT

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

Re: SAS Enterprise Guide error importing Excel from SharePoint

iblock — Tue, 22 Oct 2019 18:57:45 GMT

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

Re: SAS Enterprise Guide error importing Excel from SharePoint

ChrisHemedinger — Tue, 22 Oct 2019 19:23:14 GMT

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.

Re: SAS Enterprise Guide error importing Excel from SharePoint

Reeza — Tue, 22 Oct 2019 19:44:45 GMT

Does anyone have those files checked out?