Proc Import for Excel File and Some Columns Not Importing

[shellp55]

Hello I am using SAS to import a Excel 2010 worksheet that has 406 columns, however only 255 columns are importing.  I think I've read that there is a 255 column limit but is there no way to work around this?  The code I'm currently using is: PROC Import Out=Work.Master_A DataFile=c:\test\worksheet1 DBMS=ExcelCS Replace; Range="A1:OP101"; ScanText=Yes; UseDate=Yes; ScanTime=Yes; Run; Thanks for any assistance.

[RW9]

TBH I avoid using proc import/export.  Save the file as CSV file, then write a small datastep import program.  You then have full control over columns, formats, and conditions.  I can't see why 406 column excel sheet is even usuable.

[ballardw]

you don't show the full file name for the Excel file. Without an extension of xlsx it could be getting treated as an earlier version with a 255 column limit.