>I have an application that reads a date (formatted as Date) from an Excel file using an OleDb connection into an untyped dataset. This has been working fine, but suddenly when the date I was trying to read became 7/13/2007, the value in my dataset turned to String type of "39275". When I change the data format type in Excel to string, it becomes "39275", so that is where that value came from. How can I fix this so it loads as a date instead of a string?
Mike,
Excel internally stores the date as a numeric value (days since 12/29/1899). Formatting a cell as date changes the display but not the underlying value.
Cetin