Trying to insert data to Excel file using OLEDB

Question

I want a button in C# form to be able to insert data to Excel table.

This is what I did:

try
        {
            System.Data.OleDb.OleDbConnection MyConnection;
            System.Data.OleDb.OleDbCommand myCommand = new System.Data.OleDb.OleDbCommand();
            string sql = null;
            MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='C:\\Users\\Miko\\Documents\\WeightWatchers - Copy\\TrackingLoss.xlsx';Extended Properties=Excel 8.0;");
            MyConnection.Open();
            myCommand.Connection = MyConnection;
            sql = "Insert into [Sheet1] (Date,Loss) values(y,x)";
            myCommand.CommandText = sql;
            myCommand.ExecuteNonQuery();
            MyConnection.Close();
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.ToString());
        }

When I'm trying it, this window is open.

Anybody knows why and what to do?

SLaks · Accepted Answer · 2012-08-17 20:57:58Z

3

Extended Properties=Excel 8.0

That means Excel 97 (.xls) files, not .xlsx.

You need to use Provider=Microsoft.ACE.OLEDB.12.0; Extended Properties=Excel 12.0 Xml

answered Aug 17, 2012 at 20:57

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Trying to insert data to Excel file using OLEDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related