Reading data from excel
 

Hi All,

We have a problem in getting the excel sheet data in programming(.Net) or
DTS. Our excel sheet contains 3 lines of header which is type of string.
Other lines contains data with the type of numeric. While reading through
the program it gets only one data type (either header or data). Is there any
way to get all the data header as well as data eventhough they are different
data type?

Regards,
P.Nishanthan