How to read more than 256 columns from an excel file (2007 format) using OLEDB

by

This is a limitation on the Jet OLEDB driver. One solution that might work (i.e. I haven’t tried it) would be to breakup the sheet into named ranges that are no wider than 255 columns and query for each of those separately (e.g. Select * From RangeName) and then merge the results into a single DataTable.

More Related Contents:

  1. How do I properly clean up Excel interop objects?
  2. How to export DataTable to Excel
  3. Format excel column to decimal doing export from c#
  4. Reading Datetime value From Excel sheet
  5. How do I export to Excel?
  6. Reading excel file using OLEDB Data Provider
  7. How to get the range of occupied cells in excel sheet
  8. EPPlus number format
  9. How to read data from excel file using c# [duplicate]
  10. Excel interop: _Worksheet or Worksheet?
  11. Excel error HRESULT: 0x800A03EC while trying to get range with cell’s name
  12. How to add data table with legend keys to a MS Chart in C#?
  13. How to make correct date format when writing data to Excel
  14. Importing Excel into a DataTable Quickly
  15. Accessing Excel Custom Document Properties programmatically
  16. How can I programmatically create, read, write an excel without having office installed?
  17. How to programmatically limit bandwidth usage of my c# application?
  18. Why appending AutoFilter corrupts my excel file in this example?
  19. Open XML SDK 2.0 – how to update a cell in a spreadsheet?
  20. Exporting to .xlsx using Microsoft.Office.Interop.Excel SaveAs Error
  21. Get the Column Index of a Cell in Excel using OpenXML C#
  22. How do I get an Excel range using row and column numbers in VSTO / C#?
  23. openxml spreadsheat save-as
  24. Printing Excel using Interop
  25. How to import all the Excel sheets to DataSet in C#
  26. Scientific notation when importing from Excel in .Net
  27. Accessing an open Excel Workbook in C#
  28. As of today, what is the right way to work with COM objects? [duplicate]
  29. Import Excel to Datagridview
  30. How to create Excel file using OpenXML without creating a local file?

Leave a Comment