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
Import data from Excel to MySQL database
Re: Import data from Excel to MySQL database
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.
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.
Re: Import data from Excel to MySQL database
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.
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.