Unrecognized database format

c#, database, excel

Solution

You need to tell the provider you're using Excel 97-2003 (xls as opposed to xlsx) by appending:

Extended Properties="Excel 8.0"

E.g.

string ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\"Book1.xls\";Extended Properties=\"Excel 8.0\"";

Problem

I would like to ask, why I get this exception when I try to connect excel 2000/3 and also 2010? ``` using System; using System.Collections.Generic; using System.Text; using System.Data.OleDb; namespace md1_connect { class Program { static void Main (string[] args) { string ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\"Book1.xls\""; OleDbConnection MyConn = new OleDbConnection(ConnectionString); OleDbCommand cmd = new OleDbCommand("SELECT * FROM[Sheet2$]", MyConn); MyConn.Open(); OleDbDataReader dataReader = cmd.ExecuteReader(); while (dataReader.Read()) { Console.WriteLine(dataReader.GetDouble(0)); } MyConn.Close(); } } } ```

Original source