bakesomecakes
New member
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.
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.