dotnet datatools: Hi,

I have an application, that needs to import excel spreadsheets into a
database.

I am using an OleDBDataAdapter to load (fill) the data into a Dataset.

Occasionally, person sending us the file, will put the data starting
in column B, not column A. This fails our checks on column count.
(Also occasionally, an extra blank column after the data gets read
in).

Is there an easy way for me to get the DataAdapter to ignore blank
columns?