You can import records into your sql database in the form of an excel sheet using phpmyadmin.
Step 1: Excel sheet with records to be inserted
- Create an excel sheet with all the records to be inserted into your database.
- The columns of the excel sheet will be same as the table columns
- Format your excel sheet as per the table columns and then delete the first row with column heading
Step 2: Converting Excel into CSV
- Go to File – > Save As
- Now enter the name of the file and select the File Type as CSV, and click Save
Step 3: Importing .csv file into sql via phpmyadmin
- Select the required table and click Import
- Select the .csv file
- Format of imported file – Select ‘ CSV using LOAD DATA ‘
- Fields terminated by: Change ” ; ” to ” , ” and leave the rest as it is and click GO.
And you are done 🙂
[important]Important:Â Don’t try to import more than 50 records at a time ![/important]
A System Admin by profession, is a tech buff and a licensed Amateur Radio operator with callsign VU3DES. He is interested in Technology, Amateur radio, Electronics home-brewing, FOSS, Photography and everything tech. He uses this blog to share his views and ideas with people sharing similar interests.
Latest posts by Amogh Desai (see all)
Permalink
wow that was pretty awesome!