I need a workaround for Excel Guessing Data Types problem

by

I found a solution by adding IMEX=1 for the connection string, but there’s a special format for it which descriped in the following link.

The IMEX parameter is for columns that use mixed numeric and alpha values.
The Excel driver will typically scan the first several rows
in order to determine what data type to use for each column. If a column is determined to be numeric
based upon a scan of the first several rows, then any rows with alpha characters in this column will
be returned as Null. The IMEX parameter (1 is input mode) forces the data type of the column to
text so that alphanumeric values are handled properly.

Regards

More Related Contents:

  1. How to use Select method of DataTable
  2. Call a stored procedure with parameter in c#
  3. Calling stored procedure with return value
  4. OleDbCommand parameters order and priority
  5. Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine
  6. Pass table valued parameter using ADO.NET
  7. SQL command INSERT is working but the data not appear in table
  8. Entity Framework with NOLOCK
  9. Under what circumstances is an SqlConnection automatically enlisted in an ambient TransactionScope Transaction?
  10. Invalid attempt to read when no data is present
  11. How do I return multiple result sets with SqlCommand?
  12. Difference with Parameters.Add and Parameters.AddWithValue
  13. How to save image in database using C# [closed]
  14. Encrypt password in App.config
  15. Calling Oracle stored procedure from C#?
  16. How to run multiple SQL commands in a single SQL connection?
  17. DbArithmeticExpression arguments must have a numeric common type
  18. Connection timeout for SQL server
  19. MultipleActiveResultSets=True or multiple connections?
  20. Getting binary data using SqlDataReader
  21. Creating a SQL Server table from a C# datatable
  22. How should I multiple insert multiple records?
  23. SQL: Update a row and returning a column value with 1 query
  24. What size do you use for varchar(MAX) in your parameter declaration?
  25. From Excel to DataTable in C# with Open XML
  26. Returning a SqlDataReader
  27. Reading a date using DataReader
  28. Why does the SqlParameter name/value constructor treat 0 as null?
  29. How do I connect to a SQL database from C#?
  30. How can I Pass a Table Name to SqlCommand?

Leave a Comment