Hi, I have a database table in SQL Server which I need to get into
Excel 97. The final column in the table is a semi-colon delimited
string which is defined as length 5000 in the database. The entry with
the biggest amount of data in this field is using approx 3,950
characters (104 delimited entries each length 38 at most).

I can export this to Excel and open it no problem, however when I use
the 'text to columns' tool to convert this delimited field into
numerous columns (104 being the max in this case), it chops off all
data after about the 70th column. Before trying to convert it, I can
see the cell holds all the data ok. I've also tried exporting to csv
then importing, but its done exactly the same thing.

Does anyone know if there's a limitation on this feature in Excel 97
that stops a certain number of characters being converted? Is there
something I can do that will allow me to convert this ridiculous number
of delimited fields into columns succesfully?

Thanks