255-character limit on cell contents

Nov 20, 2009 at 2:09 PM
Edited Nov 20, 2009 at 3:18 PM

There's a limit of 255-characters of text that a cell can contain. Any text that's longer than that is truncated when it's written to the cell. Has anyone run into this and is there a workaround, or a change that I can make to the source. I've looked thru the code and it's a bit over my head. 

We are extracting data from Oracle and SQL Server tables, doing a comparison and writing the changes to an Excel spreadsheet. The spreadsheet is then uploaded to a website, where it's processed and inserted into the SQL Server tables. It's absolutely imperative that the data that gets put into the spreadsheet is not truncated. Otherwise the next time we do a comparison, we'll get false positives because of the mismatch of the data.

Anyone got any ideas?

Nevermind... it turns out the the query executed on the Oracle server was truncating the column in question; i.e. SUBSTR(really_long_column, 1, 255)