when getting excel data with ole...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello~ ^^
I have a question about getting excel data with oledbconnection.

I entered '23190000' to Excel Cell and changed Column width to small, then
the value chaged to 2E+07 or ####.
And I saved this file...(maybe both data saved..viewed data and original data)
when openning this file with oledbconnection, I got '2E+07' without original
data '23190000'.
I'd want to get original data '23190000' instead of viewed data like
'2E+07', '#####', '23,190,000'.

I used connection string like this..
OleDbConnection db = new OleDbConnection
("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + m_sarFileName[iIndex]
+";Extended Properties=Excel 8.0;" );

Thank you...
 
Back
Top