OK, it's getting late and my head aches from banging it on the desk!
I'm creating a flat file import CSV through Excel 2003. It has extended text that reaches about 500 chars. However, Excel displays the contents of this cell as a sequence of about 500 "#" signs and, when saving as a CSV, the text is being created as about 500 "#" signs. Excel has a field display width limit of 255 chars but allows for 32k in each cell (I think).
Anyone any experience here before I take one headache table too many.
Thanks
Andy
I'm creating a flat file import CSV through Excel 2003. It has extended text that reaches about 500 chars. However, Excel displays the contents of this cell as a sequence of about 500 "#" signs and, when saving as a CSV, the text is being created as about 500 "#" signs. Excel has a field display width limit of 255 chars but allows for 32k in each cell (I think).
Anyone any experience here before I take one headache table too many.
Thanks
Andy
Comment