Kod: Tümünü seç
string yol;
yol = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Inetpub\wwwroot\DenemIst\Sbs.xls;Extended Properties=Excel 12.0";
System.Data.OleDb.OleDbConnection MyCon = new System.Data.OleDb.OleDbConnection(yol);
System.Data.OleDb.OleDbCommand MyAdap = new System.Data.OleDb.OleDbCommand("select * from [Sayfa1$]", MyCon);
MyCon.Open();
System.Data.OleDb.OleDbDataReader dr = MyAdap.ExecuteReader();
System.Data.SqlClient.SqlConnection MySqlCon = new System.Data.SqlClient.SqlConnection("Data Source=MAHO;Initial Catalog=WEB;Persist Security Info=True;User ID=sa;Password=123");
SqlBulkCopy bc = new SqlBulkCopy(MySqlCon);
bc.DestinationTableName = "Sbs";
bc.WriteToServer(dr);
hatası alıyorum. acaba ofis 2007 den mi kaynaklanıyor....