Не удалось найти устанавливаемый isam (ошибка)
namespace Excel_to_Access { public partial class Defult : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { int rollno; String sname; String fname; String sclass; string path = Path.GetFileName(FileUpload1.FileName); path = path.Replace(" ", ""); FileUpload1.SaveAs(Server.MapPath("~/ExcelFile/") + path); String ExcelPath = Server.MapPath("~/ExcelFile/") + path; string mycon = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=" + ExcelPath + ";Extend Properties=Excel 8.0;Persist Security Info = False"; OleDbConnection conn = new OleDbConnection(mycon); conn.Open(); OleDbCommand cmd = new OleDbCommand("SELECT * FROM [Sheet1$]", conn); OleDbDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { //Response.Write("<br>"+dr[0].ToString()); rollno = Convert.ToInt32(dr[0].ToString()); sname = dr[1].ToString(); fname = dr[2].ToString(); sclass = dr[3].ToString(); savedata(rollno, sname, fname, sclass); } Label1.Text = "Data Has Been Saved Successfully"; } private void savedata(int rollno1, String sname1, String fname1, String sclass1) { OleDbConnection con; OleDbCommand com; con = new OleDbConnection("Provider= Microsoft.Jet.OLEDB.4.0;Data Source" + Server.MapPath("~/App_Data/StudentData.accdb") + ";Persist Security Info=False"); con.Open(); String data1; data1 = "insert into studentdetails values(" + rollno1 + ",'" + sname1 + "','" + fname1 + "','" + sclass1 + "')"; com = new OleDbCommand(data1, con); com.ExecuteNonQuery(); con.Close(); Label1.Text = "Data Has Been Upload to MS Access Database Successfully"; } } } What I have tried: <pre>string mycon = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=" + ExcelPath + ";Extend Properties=Excel 8.0;Persist Security Info = False"; OleDbConnection conn = new OleDbConnection(mycon); conn.Open();
F-ES Sitecore
google "не смог найти устанавливаемый isam", вы найдете множество возможных решений.
Richard MacCutchan
Вам необходимо установить библиотеку драйверов. Но Jet уже довольно стар, вам было бы лучше с Microsoft.Ace.OLEDB.12.0
Maciej Los
Мой виртуальный 5!