While fetching the data value from excel it retrieve 0 instead of correct value.
Hi,
I am fetching data value thorugh web downloaded excel file throguh ADO method. i am doing this through microsoft database access engine because excel file is not installed at my end. I faced an issue while fetching the data which is mentioned below.
There are 4 coloumn in file with name 'Name, 'Sample','Address','Zip'. I am able to fetch the correct value for three column 'Sample','Address','Zip but unable to get the correct value for 'Name' column as it show '0' instead of correct name.
I investigates the issue and observed that this happens because of file is in protected mode.Would you please help me in to turn off the protected mode of the file through code.
Thanks,
Vinay
I am fetching data value thorugh web downloaded excel file throguh ADO method. i am doing this through microsoft database access engine because excel file is not installed at my end. I faced an issue while fetching the data which is mentioned below.
There are 4 coloumn in file with name 'Name, 'Sample','Address','Zip'. I am able to fetch the correct value for three column 'Sample','Address','Zip but unable to get the correct value for 'Name' column as it show '0' instead of correct name.
I investigates the issue and observed that this happens because of file is in protected mode.Would you please help me in to turn off the protected mode of the file through code.
Thanks,
Vinay
