Long ago I blogged about using PowerShell to read out an XLS(X) file using ADO.Net. Until recently, only the x86 version of the ODBC driver was available.
Fortunately, Microsoft recently release a x64 version of the drivers as part of the Microsoft Access Database Engine 2010 Redistributable Package. Download link:
Interestingly, while this package is labeled “Office 2010”, the provider’s names references “Office 12” (2007) –> this should have be released earlier 🙂