I've never used Sybase. Some clues:

1. Excel truncates cell contents after 255 characters.
2. If your query determines a column to be numeric (scanning n rows only)
and then finds that some rows have characters, those rows are lost.

You might consider researching SCHEMA.INI on Google.

"Ann Rossi" wrote:

Hi,
I've set up a simple query to a Sybase database (select * from tablename) where
some of the fields contain text strings. No matter what I've tried (not that I'm
an expert in Excel), the text is cut off after a few characters in a seemingly
random way (in some cases, I get 5 characters and in others 14).
Anybody know how to fix this?
Any help is much appreciated, Ann Rossi,