Re: Excel vs MySQL

[Javier Treviño]

Hi Amit,
Thanks for writing in our forums!

Just given the fact that your data is growing at an average of 10K rows per month I would consider migrating to a DBMS and MySQL is an excellent choice.

I guess you are planning to continue using Excel as a front-end if you migrate your data to MySQL. You can enforce uniqueness in your data by using unique indexes. Bear in mind that you will get errors (thrown back by the MySQL server) anyway when trying to insert the duplicate data with any program you use.

With MySQL for Excel if I remember correctly, you may be able to insert the non-duplicate data anyway using the Edit MySQL Data feature, you may be able to use the Append Data feature as well, but it may rollback the append if any error is thrown back from the server.

I still think you need to move from Excel to a robust database given the amount of data you are storing, and my advice would be to play with MySQL for Excel to see if it will do what you need.

Best Regards.

====================================
Javier Treviño
MySQL on Windows Team