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?