all rows from excel are not getting imported to datatable using oledbconnection

[reshmajoshi]

Hi all, I am stucked up at this point. I searched alot on gooogle but didnot find anything. My problem is: I have an Excel file which i want to export to datatable and from datatable i want to save it to oracle DB. Excel file contains multiple columns and each column consists of large data(approx 20000characters/numbers). using oledbconnection (http://codehill.com/2009/01/reading-excel-2003-and-2007-files-using-oledb/),excel columns with such large data are not imported to datatble.(Small data columns gets copied). Can anyone suggest workaround to my problem??? Thanks in advance.

[samueal]

"(Small data columns gets copied)".
Can i know how many rows ?

You import some values to datatable and add in database,
and again import some values and add in database.

Try this?