IMPORTANT NOTICE: As of 21 February, anything posted in this community WILL NOT BE MIGRATED to our new community site. We have pulled all user information and data from this site and are now in an approximately week long process of importing users, roles, and data to our new site. We are leaving this site open and active so you can post and hopefully get a response until the migration is complete. Once complete, the URL that currently takes you to this site will take you to our new site so your bookmarks will work as always. Please read the information on a New Login Process
This is a known problem with the Microsoft ODBC driver and is not a Silk Test issue. The problem arises because the ODBC driver parses the first eight lines of the spreadsheet to determine the length of the data to be returned; if all of those rows are of 255 characters or less then any subsequent rows that exceed 255 characters will be truncated.
A full explanation can be found here:
A possible solution would be to put the longest data string into one of the first eight rows.