hi,
i'm using the .net OleDBprovider to read the data from excel file...
but sometimes the data from the few of the cells of excel gets truncated...
i'm not getting the whole data..if the data length is greater than 255
characters...

how can i solve this problem?

[quoted text, click to view]

¤ hi,
¤ i'm using the .net OleDBprovider to read the data from excel file...
¤ but sometimes the data from the few of the cells of excel gets truncated...
¤ i'm not getting the whole data..if the data length is greater than 255
¤ characters...
¤
¤ how can i solve this problem?

Try changing the TypeGuessRows setting in your Registry:

Data truncated to 255 characters with Excel ODBC driver
http://support.microsoft.com/kb/189897


Paul
~~~~