Oledb length issue - Accepts only 255

[VijayRama]

Hi All,

I read the excel file using Oledb and store it in dataset in asp.net.

One column in excel file has more than 1000 characters, but it
retrieves only 255 charcters, since the first row is of length 2.

I googled some options for this and found that we can use odbc. But
its not possible to install that driver.

Please suggest any ideas.

 

[Guest]

Hi All,

I read the excel file using Oledb and store it in dataset in asp.net.

One column in excel file has more than 1000 characters, but it
retrieves only 255 charcters, since the first row is of length 2.

I googled some options for this and  found that we can use odbc. But
its not possible to install that driver.

Please suggest any ideas.

I am not 100% sure about this but try to add "IMEX=1;" to your
connection string or create schema.ini file