Set the datatype for a column via excelReader.AsDataSet()

Dec 2, 2013 at 9:11 PM
I have a weird issue when I read an excel workbook and the column starts off as a set of numbers and then switches to alphanumeric. I need to force the asDataSet to set mixed column data to text... The dataset object sets it to typeof object... any ideas or examples?

Example:
Serial-------------------Tag--------------Room-----------Status
00234567z-------------T001------------104-------------In Use
00234567z-------------T002------------104-------------In Use
00234569z-------------T003z-----------104-------------In Use
00234570z-------------T004z------------104-------------In Use
00234571z-------------T005z------------112-------------In Use