Why does ExcelQueryFactory only return 255 columns

Question

I have a spreadsheet that has about 500 columns. When I execute the linq query below, it only returns 255 columns. Is that a limitation on ExcelQueryFactory? Could it be an issue with my spreadsheet?

var book = new ExcelQueryFactory(filePath); var data = from x in book.Worksheet("MyStatisticSheet") select x;

Answer 1

It's a limitation of the Jet and Access Database Engines that LinqToExcel uses.