"Text to Columns" Conversion Dropping Cols
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 |
All times are GMT +1. The time now is 02:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com