Creating MYSQL Insert and Update statements with EXCEL

There are times when you need to manipulate data with excel before importing it into a database. Excel does have functionality which can be used to connect the spreadsheet directly to a data-source such as a SQL database, however this is not always practical. Using Excel formula’s you can easily…