>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.
Thanks