Search code examples
ms-accessoledb

"Could not find installable ISAM" using OLEDB

I am trying to connect to an Access database and get the data to CSV but I received the error

Could not find installable ISAM

This is my connection string: 

string connectionStringMSAccess = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + System.IO.Path.Combine(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location), @"database\whitelist.mdb") + "';Extended Properties=text;HDR=Yes;FMT=Delimited";

What is wrong with it?

Solution

  • Remove the ;Extended Properties=text;HDR=Yes;FMT=Delimited parameters from your connection string. They are not applicable when opening a connection to an .mdb file.