How to connect to file-based data sources (Microsoft Access , Microsoft Excel and Text files ) from a 64 bit application

  The Issue: A 64-bit process can load only 64-bit components in it’s process boundary. Same is true for a 32-bit process also. So, if your application is 64 bit, you will need a 64-bit provider or driver to connect to  Microsoft Access (mdb, accdb) or Microsoft Excel 2010 (xls, xlsx, and xlsb) or  text…