// string connectionString = "Provider = Microsoft.ACE.OLEDB.12.0; Data Source=" +
// "C:\\Users\\Administrator\\Desktop\\1.xlsx" + "; Extended Properties=Excel 12.0";string str = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + "C:\\Users\\Administrator\\Desktop\\1.xlsx"
+ ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=1;'";
OleDbConnection test = new OleDbConnection(str);
test.Open();
if (test.State == ConnectionState.Open)
MessageBox.Show("SUCCESSFUL!!!");
connectionString 和str字符串格式同样能够成功,注意空格,最好直接粘贴修改参数即可