title: adding data from excel to existing table in MySQL
body: <p>I have an existing table on MySQL with 7 fields - 4 are integer(one acting as primary key and auto incremete) and  3 text. This table already has data.</p>
  
  <p>I am collecting new data in Excel and wish to bulk-add the data to the Mysql table. Some of the cells in Excel will be blank and need to show as null in MySQL and the primary key won't be part of excel, I let MYSQL auto add it. Previously I was manually adding each record through PHPmyadmin but it is far too time consuming (I have 1000's of records to add).</p>
  
  <p>How do I go about this in terms of setting the Excel sheet in the right way and making sure I add to the exsisting data instead of replacing it? I have heard CSV files are the way? I use PHPmyadmin if that helps.</p>
  
  <p>Thanks</p>