I am trying to import some data from excel.
i am using visual studio 2008 .net 3.5, on win xp sp3

the data that is being imported form excel is being edited somewhere in the import.

i am sure it is somthing todo with the olddb connection.

the data is coming out like this 6.05708e+008

the connection string goes somthing like this:
("provider=Microsoft.Jet.OLEDB.4.0; Data Source='C:\test.xls'; Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";")

i have tryed change the IMEX value to 0,1 and 2. nothing seems to work. each time the data is imported incorrectly.


Could anyone please help. i am been working on this non stop for 2days and i am getting now where quickly. and my client is going nuts, i depend on this job to pay the rent.


all comment welcome.