data_null_ you are right with your remark to Arthur. as that L-archive changing the number is actually changing the windows registry HKLM\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel\TypeGuessRows (jet 4.0) that is coming form an era it was common to do that kind of work in open desktops. Today you are supposed to us a restricted user not capable to do that and an admin user for updating your machine. The last not commonly allowed as result of desktop policies. All office versions are using a different setting Arthur Tabachneck I was confronted with all desktop problems where this was not working correctly. (closed ones with a repackage requiement). The surprises of inconsistent behavior (MDAC JET ACE) at the different SAS version have brought met to hate what is behind the screens there. Most can be found as MS issues then seeing the same with SAS. No, SAS is not telling everything what they have done behind that, but I a lot van be deduced. Some notes are more clear like 37412 - Errors occur when you import Microsoft Excel or Microsoft Access files into SAS® 9.2 or 37612 - The SAS® System can only import and export 255 variables when you access a Microsoft Excel 2007 file or 45496 - An error occurs when you create an Excel sheet with a string greater than 255 characters using SAS/ACCESS® Interface to OLE DB for Eguide 50661 - An error might occur when you import Microsoft Office data using SAS® Enterprise Guide® 5.1 or 6.1 that 255 limitation can be found as a generic ACE limitation the bitness foro DLL differences.
... View more