From: Ed on 26 Jul 2010 14:16
Try converting the xlsx file to a csv or txt file using the SW that
originally created the file. May have to change the GUESSROWS to bring
in the data in the correct format.
> Use the regular import, only import 255 columns.
> proc import datafile="C:\temp\aaa.xlsx"
> sheet='Final Data';