Import data from Excel to MySQL database

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
adriana.m
Posts: 2
Joined: Fri 11 Apr 2014 12:23

Import data from Excel to MySQL database

Post by adriana.m » Fri 11 Apr 2014 12:35

Hi!
I'm looking for the best solution for import data from excel files to database. If someone has experience in this case please give me advice.

Has DotConnect for MySql sufficient support (maybe MySqlLoader class)?

This is .net MVC application.

Thanks,
Ada

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Import data from Excel to MySQL database

Post by Shalex » Mon 14 Apr 2014 11:27

Please take a look at the Data Import Wizard feature of dbForge Studio for MySQL which allows to import data from MS Excel to MySQL: http://www.devart.com/dbforge/mysql/stu ... mport.html.

If you need to migrate data in .NET code, MySqlLoader will help you to load data into MySQL database but you should employ an additional .NET provider to read data from Excel: http://stackoverflow.com/questions/5852 ... -xls-files.

adriana.m
Posts: 2
Joined: Fri 11 Apr 2014 12:23

Re: Import data from Excel to MySQL database

Post by adriana.m » Mon 14 Apr 2014 12:40

Hi,
thanks for your answer. I use sometimes wizard, but now I have to develop small web app to import data.

Now I'm testing NPOI to read/write Excel files and I'm going to use MySqlLoader.

Post Reply