Read all values excel as string

[msjonathan]

Hej,
I can read an excel 2007 file, but it reads 13:15 as a date. So I searched for a good connection string on Connectionstrin gs.com and found one I had to add an extended property IMEX=1

 ConnectionsString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" +
 pImportTemplate.Location + ";Extended Properties=\"Excel 8.0;HDR=YES;IMEX=1\"";

And I did so but when I get my Datetable, It's still in the Date format.

Has anyone a solution?

Greetz jonathan

[msjonathan]

All my data in the column are dates, so there is no difference in the column items.

Greetz Jonathan