Boolean Problems

Feb 18, 2010 at 6:15 PM

I have a column which is simply a text TRUE or FALSE however after after putting it into a dataset (Dim result As DataSet = excelReader.AsDataSet()) the entire column is completely blank.

The only way I have figured to fool it is to place a single quote in front of the TRUE/FALSE and then it pulls everything in just fine.  Doesn't seem to make a difference whether I use .xls or .xlsx.

 

Any ideas how I could get it to pull in the values properly?