Import data from Excel to MySQL database

Import data from Excel to MySQL database

Postby 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
adriana.m
 
Posts: 2
Joined: Fri 11 Apr 2014 12:23

Re: Import data from Excel to MySQL database

Postby 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/studio/data-export-import.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/5852678/net-excel-library-that-can-read-write-xls-files.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Re: Import data from Excel to MySQL database

Postby 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.
adriana.m
 
Posts: 2
Joined: Fri 11 Apr 2014 12:23


Return to dotConnect for MySQL