How can i populate database tables from excel spreadsheet

Recently i got a excel spreadsheet document with a couple of thousand records which needed to be put into the database, I use MySQL so i had to prepare equal number of insert queries for the number of records in the excel spreadsheet, but instead of doing it the manual way i did it the easy way and this is how it was done. I hope it helps you too. Do let me know your thoughts.

About: Anand

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.