1

CSV file one of the column contains both integer and string values, uploading using C# Oledb provide string values are loding.

Reason for that more values are in integer datatype, string values are not loading. If string values are more both integer and string values loading.

Jagan
  • 21
  • 5
  • the first step to solving the problem would be you posting some code and sample data – Cristian Lupascu Oct 19 '12 at 06:30
  • I got solution from below link. http://stackoverflow.com/questions/115658/when-reading-a-csv-file-using-a-datareader-and-the-oledb-jet-data-provider-how. – Jagan Oct 19 '12 at 10:41

1 Answers1

-1

Change datatype of column as String in excel then try to upload the data ...

Neeraj Kumar Gupta
  • 2,157
  • 7
  • 30
  • 58
  • That is daily task run at midnight – Jagan Oct 19 '12 at 07:24
  • Thanks for you quick response i got the solution from below link.http://stackoverflow.com/questions/115658/when-reading-a-csv-file-using-a-datareader-and-the-oledb-jet-data-provider-how – Jagan Oct 19 '12 at 10:43