Pushing data from Excel
Often, data is first stored in Excel before it is transferred to a database. This can happen for many reasons; most commonly, it is because the data is exported from a tool that can interface with Excel but not directly with a database.
In situations where you want to move data from Excel to MySQL, you can utilize the Export Excel Data to New Table functionality. This will create a new table in MySQL and load the Excel data into it. This functionality allows for the quick and easy loading of data.
Exercise 12.06 – pushing data from Excel to a new MySQL table
Excel is often used in business as a database and can hold a lot of organized data. When the data requirements have outgrown Excel, often the decision is made to migrate the data to a proper RDBMS such as MySQL. Without a doubt, at some time in your career, you will need to migrate data from Excel to a new table in MySQL. This exercise will show you how to do that with ease using MySQL for...
