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.
=CONCATENATE("insert into users (firstname,lastname,'Email', createdon) values ('";A3;"', '";B3;"', '";C3;"', NOW())")