Devart Forums

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

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.

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.