determinig datatype in excel

L

latha

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?
 
J

JoseValencia

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 connection to Excel 2007 *.xlsx files? 8
OLEDB rounding percents incorrectly? 0
Macro doesn't work any more 0
Paste to excel from word - auto format problem 1
ADO connection to a protected workbook? 3
Imported Excel file and datatypes - HELP!!! 4
Help to get data from excel 2003 worksheet into Visual Basic 6 1
ADO.NET truncates excel data 0

Top