anandkanatt.com
my tech blog!
  • Home
  • About
  • Contact

How can i populate database tables from excel spreadsheet

Anand Databases, Languages, MySQL, SQL April 14, 2013

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
Read More »

  • Home
  • About
  • Contact
Recent Posts
  • How do i plan my career in IT ?
  • How can i populate database tables from excel spreadsheet
  • How do i use joins in sql ?
  • How do i detect if a browser window is closed or refreshed ?
  • Google Chrome Popup Detection that actually works !

© 2019 anandkanatt.com | Designed by TechEngage. | Powered by WordPress.