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

Question

I am trying to import an excel file with over 256 columns using OLEDB in C #. I tried all kinds of things, but it is not possible to read more than 256 columns from an Excel file (2007 format). I am wondering if this is a mistake, or I just missed something. Here is the connection string I used:

Provider = Microsoft.ACE.OLEDB.12.0; Data Source = c: \ myFolder \ myExcel2007file.xlsx; Advanced Properties = "Excel 12.0

Answer 1

Jet OLEDB. , (.. ), , 255 , (, Select * From RangeName), DataTable.

Answer 2

excel 256 , Oledb, . Oledb 255 .

, ExcelDataReader DLL. , Microsoft Excel .NET.

ondrive : cheers!!

https://onedrive.live.com/?id=4B1F6C3E92F6522C%21257&cid=4B1F6C3E92F6522C&group=0&parId=4B1F6C3E92F6522C%21125&authkey=%21AMbQad-vwusjl-4&o=OneUp