solution for this problem is to put 'IMEX=YES' Attribute in connection of oledb.this fetches the data from the excel column as text format.

try it
this will work

If anyone is trying to put a number into a cell of a CSV file with a preceding 0 or zero, then add a preceding "'" character e.g."value1","value2","'001234". Excel grumbles but Customers are happy!

Jesus == Way == Truth == Life == Love == God

Hi Ajimi
  Can u please Post me the asp code for
"asp page that reads any CSV file, retrieves the data and displays on the page" no need to send to sql. just display.
My email id is [email protected]
And its urgent
Thanks in advance

I ma getting same problem which describe below


Hello everyone, I'm having the some problems parsing CSV and Excel files. I can retrieve a numerical data like 5 digit zip code but cant retrieve a string data which is 9 digit zip code with "-" between them in a same Zip code field. Any one has an idea about this problem?

PLEASE SEND ME C#.NET code to resolve it ...It is very critical

Send me at [email protected]

Please be needful

Thanks in advance