MySQL Forums
Forum List  »  MySQL for Excel

Excel vs MySQL
Posted by: Amit Nair
Date: August 06, 2014 08:57AM

I am a complete newbie and wanted some advice on whether I should install/use MySQL for my growing database. I currently have a growing database as an excel workbook. The database has >110,000 entries and grows at >10,000 per month.

-Entries are all text.
-Each time i add new entries (~10,000) i need to highlight any duplicates that may be there and remove them
-I've managed to do this in excel, however as the database grows, comparing new entries with existing ones is taking considerable time on excel. Also a majority of times Excel does not completely identify all duplicates

So my question is
Will an alternative such as MySql make this process any quicker?
Am I less likely to get errors? i.e. inability of excel to identify all duplicates

Thanks in advance for your help

Options: ReplyQuote

Written By
Excel vs MySQL
August 06, 2014 08:57AM
August 06, 2014 02:36PM
August 23, 2014 12:11AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.