Import excel file to C# using OLEDB

See more:

C#

OleDb

I want to show an excel file in a datagridview when a button is pressed. Here is the code for the button click event:

private void button1_Click(object sender, EventArgs e)
{
    string fileName = "C:\test.xlsx";
    string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="   + fileName + ";Extended Properties=\"Excel 8.0;HDR=YES;\"";
    OleDbConnection con = new System.Data.OleDb.OleDbConnection(connectionString);
    con.Open();
    OleDbDataAdapter cmd = new System.Data.OleDb.OleDbDataAdapter("select * from [SHEET1$]", con);
    DataSet excelDataSet = new DataSet();
    cmd.Fill(excelDataSet);
    xl.DataSource = excelDataSet.Tables[0];
    con.Close();
}

But always I get an OleDbexception which says "Failure Creating File" pointing a yellow arrow to the 'con.Open();' line
Please help me what can I do.