Read an Excel 2007 file (.xlsx) in C #

Question

My code was enough to read the xls file in C # (using Microsoft.Jet.Oledb.4.0), but when I tried to read the Office 2007 file (xlsx), it did not work. I searched and found that it can be read using Microsoft.ACE.Oledb.12, I tried and it worked. Can someone tell me the difference between the two? and why the xlsx file cannot be read using the Microsoft.Jet.Oledb.4.0 provider.

Answer 1

ACE(Access Database Engine) is only the successor Jet, it is still the reverse, but it also supports the new features in it - the new default .accdb file format.

Wiki:
http://en.wikipedia.org/wiki/Microsoft_Jet_Database_Engine

, :
http://blogs.msdn.com/b/access/archive/2005/10/13/480870.aspx