https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Reading-Microsoft-Access-with-ODBC/m-p/3122#M140 Hi:<BR /> This Tech Support note is fixing a slightly different length issue with ODBC, but the technique may work for your MS-Access table.<BR /> <A href="http://support.sas.com/techsup/unotes/SN/017/017463.html" target="_blank">http://support.sas.com/techsup/unotes/SN/017/017463.html</A><BR /> <BR /> Otherwise, your best bet may be to contact Tech Support for more specific help on this issue.<BR /> <BR /> cynthia Thu, 17 May 2007 20:31:21 GMT Cynthia_sas 2007-05-17T20:31:21Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Reading-Microsoft-Access-with-ODBC/m-p/3121#M139 Does anyone use ODBC? I am reading an Access database with PROC SQL on an ODBC connection. My problem is that SAS is treating all character columns as $255. Is there a way to re-format these columns within the SQL? Thu, 17 May 2007 20:20:21 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Reading-Microsoft-Access-with-ODBC/m-p/3121#M139 Petersi 2007-05-17T20:20:21Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Reading-Microsoft-Access-with-ODBC/m-p/3122#M140 Hi:<BR /> This Tech Support note is fixing a slightly different length issue with ODBC, but the technique may work for your MS-Access table.<BR /> <A href="http://support.sas.com/techsup/unotes/SN/017/017463.html" target="_blank">http://support.sas.com/techsup/unotes/SN/017/017463.html</A><BR /> <BR /> Otherwise, your best bet may be to contact Tech Support for more specific help on this issue.<BR /> <BR /> cynthia Thu, 17 May 2007 20:31:21 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Reading-Microsoft-Access-with-ODBC/m-p/3122#M140 Cynthia_sas 2007-05-17T20:31:21Z https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Reading-Microsoft-Access-with-ODBC/m-p/3123#M141 I think you just want the DBMAX_TEXT=n option on your libname statment or dataset option. Check out the documentation on it. The value you set becomes the maximum width that will be read. The maximum is 32767. HOWEVER, one thing I did notice is that my programs did get slower the higher I set it, so be careful about going overboard with it. (I don't have any examples because I switched jobs recently and no longer have a need for it). Message was edited by: Douglas Martin Fri, 18 May 2007 14:33:32 GMT https://communities.sas.com/t5/Microsoft-Integration-with-SAS/Reading-Microsoft-Access-with-ODBC/m-p/3123#M141 DouglasMartin 2007-05-18T14:33:32Z