Thanks for the info John. I'll bow to your expertise on this subject.
~~Bonnie
>Hi Bonnie:
>
>I've done a lot of importing with excel into datasets and the problem is with the implicit conversions to types in the dataset. For example, excel stores the date as the number of days from 1/1/1980 so it doesn't convert cleanly and can cause errors. Our import class was a mess to program for all the variability in the excel import.
>
>
>
>>If you already know what the structure of the DataSet will be, start out with an .xsd already pre-defined with the datatypes, add the .xsd to your Solution and VS will generate a Typed DataSet for you. Then import your Excel into that Typed DataSet that was generated from the .xsd.
>>
>>I'm assuming this will work, but I haven't messed with importing Excel data.
>>
>>~~Bonnie
>>
>>
>>>I am importing an Excel sheet into a dataset. So, of course, everything is now in character type. How can I update the dataset to specify that some columns are not integer and types like that?