I posted this 2 days ago and got no response.

I'm importing an Excel file into a DS:

da.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileName + ";" + "Extended Properties=Excel 8.0;";
DataSet ds = da.ExecuteQuery("select * from [New Quote$]", CommandType.Text);

When I look at the DS in the DS Browser, the Quantity columns are empty. The data is there in the Excel file.

The Quanties export to CSV, so if I had to I could force the file to a CVS, the parse the CVS, but that's alot of work.

Anyone have any thoughts on why this is happening?