04-09-2014 12:58 PM
I'm using SAS 9.3 (TS1M2) 64-bit with Microsoft Office 2010 32-bit. I have installed the 32-bit version of the pc file server.
I have followed 35563 - The location of the TypeGuessRows registry is different in SAS® 9.2 Phase 2 than in SAS® 9.1... and modified the TypeGuessRows to equal 0. Within the excel file I would like to import there is a column that has notes and this can be up too 5000 characters. When I use this code
dbms= excelcs replace ;
The notes column comes back as 1024, but when I replace "ExcelCS" with "XLS" as the DMBS value I get the correct max character length. Is there a way to get the correct length using the PC File server value (ExcelCS)?
Thank you for any help,