Hi,

I am creating an application which uses OleDb to connect to an Excel spreadsheet and read the data into DataTable. The problem that I am having is that some of the columns I am getting are coming up blank, I've managed to narrow down that this is because that the first few lines for that column are blank.
As unfortunately this is valid in the context of the Excel spreadsheet as not all dates etc. are required to be filled in.
I was wondering whether anyone knows of any way that I could go about ensuring that the columns are populated by the OleDbDataReader even if the first x number of rows have that column as blank.

Thanks for any help in advance.

Satal