Scientific notation when importing from Excel in .Net

by

One workaround to this issue is to change your select statement, instead of SELECT * do this:

"SELECT Format([F1], 'General Number')  From [Sheet1$]"
 -or-
"SELECT Format([F1], \"#####\")  From [Sheet1$]"

However, doing so will blow up if your cells contain more than 255 characters with the following error:
“Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.”

Fortunately my customer didn’t care about erroring out in this scenario.

This page has a bunch of good things to try as well:
http://www.dicks-blog.com/archives/2004/06/03/external-data-mixed-data-types/

More Related Contents:

  1. Reading excel file using OLEDB Data Provider
  2. Reading Excel files from C#
  3. How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
  4. Using Excel OleDb to get sheet names IN SHEET ORDER
  5. Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine
  6. OLEDB Parameterized Query
  7. OleDbParameters and Parameter Names
  8. How to read an excel file in C# without using Microsoft.Office.Interop.Excel libraries
  9. How to read file using NPOI
  10. How to open an Excel file in C#?
  11. EPPlus number format
  12. How to read data from excel file using c# [duplicate]
  13. BUG: Can’t choose dates on a DatePicker that fall outside a floating VSTO Add-In
  14. How to make correct date format when writing data to Excel
  15. Importing Excel into a DataTable Quickly
  16. How to save workbook without showing save dialog with Excel interop?
  17. Optimal way to Read an Excel file (.xls/.xlsx)
  18. Why appending AutoFilter corrupts my excel file in this example?
  19. Is there a “proper” way to read CSV files [duplicate]
  20. How to import all the Excel sheets to DataSet in C#
  21. EPPlus – LoadFromCollection – Text converted to number
  22. As of today, what is the right way to work with COM objects? [duplicate]
  23. When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?
  24. Import Excel to Datagridview
  25. .Net Excel Interop Deleting a worksheet
  26. Distinct not working with LINQ to Objects
  27. How do I determine the owner of a process in C#?
  28. How do I restart my C# WinForm Application?
  29. Change border color in TextBox C#
  30. How to convert date format to DD-MM-YYYY in C#

Leave a Comment