How to insert data values from excel to database using ms interop in c#

Question

I need some help we are going to import the data from excel to mysql database and we're going to use the MS Interop. We don't know how to start and we do some research about the MS Interop but we don't know how to start. We only now is declare the namespace we don't know what's next.

We found some youtube tutorials but they are using OLedb(if this is right), I hope you can help us!

Are you sure you need interop? There are easier ways if you're working with .xlsx files. — Crowcoder
– Crowcoder, Commented Sep 17, 2017 at 10:42
You can use the OpenXML SDK, or an abstraction of it like the ClosedXML library. I believe there's another one called Epplus. — Crowcoder
– Crowcoder, Commented Sep 17, 2017 at 11:04
I've searched about the OpenXML is this only for creating an excel file? I don't see instruction for importing or something.. — Michelle
– Michelle, Commented Sep 17, 2017 at 11:14
It is a complete SDK for MS Office files. It can be complicated, ClosedXML is an abstraction over it to make it easier. You can still do most anything with Excel and there are a lot of examples. — Crowcoder
– Crowcoder, Commented Sep 17, 2017 at 11:23

shA.t · Accepted Answer · 2017-09-17 14:00:17Z

2

You can use ExcelDataReader or Microsoft.Office.Interop.Excel as described in this answer, to read data from your sheet, then create a SqlCommand, like insert into myTable (column1, column2) values (1, 'mydata') and execute it over a connection to your MySQL Database.

answered Sep 17, 2017 at 14:00

shA.t

17k5 gold badges59 silver badges121 bronze badges

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

Collectives™ on Stack Overflow

How to insert data values from excel to database using ms interop in c#

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related