http://sourcecodezone.com/test.xls
I'm not able to import this one record to sql server 2000. It gives buffer limit exceeded. Why is it displaying characters like this? if i limit the characters to 255 it's normal. I tried to simulate this like below.
Open notepad. Create a small text within double quotes and paste in excel. Now double click that cell and add more characters so taht it will cross 255. now you will see # symbols.
I tried changing the format to text. Now when you right click the cell and hit properties. it will show hashes again.
What property is this and how do i make it go back to normal. This record is just one example of millions of records i have to import. Pls help.
-Vivek