Keep text columns in Database Query from truncating to 255 charact Owen Davies 05.07.2006 17:19:01 I have an excel sheet which pulls in data from another excel sheet using a database query (so that I could do some SQL select logic). I have two text columns in this query which behave differently, one imports results truncated to 255 characters while the other allows more (900+) characters. I can not discern any difference in these two columns in either the source workbook or the destination. They are both formatted as General, both returned as part of the same SQL query, both contain only text entries (none which Excel would like to consider numeric). Why is excel truncating one and not the other. How can I get both to return all the characters present in the source workbook? Thanks