Problem Retrieving From Excel in C#

[xia0jie]

Hi all, Im using the following codes to retrieve records from excel file.

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0 ; Data Source=" + Path + "; Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'");

OleDbCommand cmd = new OleDbCommand("SELECT TOP 10 * FROM [Sheet1$] WHERE [Project] <> ''", conn);

DataSet ds = new DataSet();
da = new OleDbDataAdapter(cmd);
da.Fill(ds);

DataTable table = ds.Tables[0];

In the excel file, there's a column storing values such as "IRAS 2009", "Nov-07" etc. When i retrieve from the DataTable it return me NULL and "31-Nov-07" respectively.

Why is it so? Why im unable to get the exact value and those in the excel file? Any help is greatly appreciated.

[GaryTexmo]

I'm unsure about why "IRAS 2009" goes to NULL, but I'm pretty sure the date is a formatting thing. If it's an actual date in excel, then yea, your data table is just giving you a different format, but it's still the same date.

You can either change it to a string in excel, or format the date on output differently. The latter would probably be the better choice ;)