Nov 11, 2013 12:46 PM|MGuser|LINK
I think I figured out the cause of the issue.
One of the columns I am trying to read has dates. In the bottom of the sheet (about 8-10 lines down) I have some assumptions stated that have some numbers in that partcular column. When those numbers are big then this issue arises.
I forced the code not to read the rows where i add text for information purposes by using this code:
OleDb.OleDbDataAdapter oleda = new OleDb.OleDbDataAdapter("select * from [" + sheetName + "] where Number is not null", conn)
Thanks for your responses.