I have a file uploader in a web page which allows to upload excel files only, hwat I want to do is in the code , to open the excel file and get the values in the excel file which Is in different cells to the mdf file in visual studio 2008, how can I do this
I an using Asp.NET and C#
I tried out but I need a help ,
If someone could give me a link or some guidelines
Appreciate a lot
thanxxxx
I have a file uploader in a web page which allows to upload excel files only, hwat I want to do is in the code , to open the excel file and get the values in the excel file which Is in different cells to the mdf file in visual studio 2008, how can I do this
I an using Asp.NET and C#I tried out but I need a help ,
If someone could give me a link or some guidelines
Appreciate a lot
thanxxxx
can't remember which one of these actually works but one of these does you will just have to try it out
//OleDbConnection conn;
//OleDbCommand comm;
//OleDbDataReader dr;
//Response.Write(Server.MapPath("Query2.xls"));
//conn = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " + Server.MapPath("Query2.xls"));
//conn.Open();
//OleDbDataAdapter da = new OleDbDataAdapter();
//da.SelectCommand = new OleDbCommand("Select * from [users$]", conn);
//comm = new OleDbCommand("Select * from Query1", conn);
//OleDbDataAdapter da = new OleDbDataAdapter("Select * from usersExport", conn);
//comm
//OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("koldb.xls")+";Extended Properties=Excel 8.0");
//OleDbDataAdapter da = new OleDbDataAdapter("select * from [Sheet1$]", con);
//DataTable dt = new DataTable();
//da.Fill(dt);
can't remember which one of these actually works but one of these does you will just have to try it out
//OleDbConnection conn;
//OleDbCommand comm;
//OleDbDataReader dr;
//Response.Write(Server.MapPath("Query2.xls"));
//conn = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " + Server.MapPath("Query2.xls"));//conn.Open();
//OleDbDataAdapter da = new OleDbDataAdapter();
//da.SelectCommand = new OleDbCommand("Select * from [users$]", conn);//comm = new OleDbCommand("Select * from Query1", conn);
//OleDbDataAdapter da = new OleDbDataAdapter("Select * from usersExport", conn);
//comm//OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("koldb.xls")+";Extended Properties=Excel 8.0");
//OleDbDataAdapter da = new OleDbDataAdapter("select * from [Sheet1$]", con);
//DataTable dt = new DataTable();
//da.Fill(dt);
hey waht do you mean ine of these how many are there, can you separate and describe the lines,
please
thanxx
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.