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.

14. April 2013 by Anand
Categories: Databases, Languages, MySQL, SQL | Tags: , , , , , | Leave a comment

Leave a Reply

Required fields are marked *