determinig datatype in excel

G

Guest

Hi
I am using aso.net 2005 with excel with the following settings

rk.SetValue("ImportMixedTypes", "Text");
rk.SetValue("TypeGuessRows", 0);
Imex=1
HDR=Yes

I am having problem when reading "2012101", it is converting into
"2.01214e+006" automatically.
I do not want this conversion and at the same time, i cannot format
someone's excel sheet.

Can someone tell me how to read data as it is?
 
G

Guest

Hi latha,
I have the same problem , please if you have fixed it let me know replying
in the newsgroup
Thanks in advacne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO with mixed data 2
Imported Excel file and datatypes - HELP!!! 4
ImportMixedTypes 1
OleDb Provider for Excel Not Reading Properly 3
Excel data mismatch 1
Reading data from Excel Worksheet in vb 3
Excel 2007 connection via oledbconnection 2
Excel Data Truncated to 255 Characters 0

Top