LexiConn Knowledgebase

Knowledgebase Home | Favorites Knowledgebase Home | Favorites
Search the Knowledgebase Browse by Category
Import Data through phpmyadmin
Article Details

Last Updated
27th of June, 2008

User Opinions (4 votes)
100% thumbs up 0% thumbs down

How would you rate this answer?
Helpful
Not helpful

It is possible to import tables to your MySQL database using phpMyAdmin if they are in .csv (or comma-separated) format. The table must already be created, the .csv file you upload must not have the column labels included, and the datatypes must match the datatype definitions of your MySQL columns.

To convert an Excel sheet to .csv format, click "Save as" then under "Save as type" scroll down and select CSV - comma delimited "*.csv"

export_csv

Log into phpMyAdmin, select your database from the drop-down box, then select the appropriate table in the left navigation panel.

phpmyadmin_import

Click on the "Import" tab on the top:

Click "Browse" and select the .csv file you would like to import, then select CSV under "Format of the imported file". In the "Fields terminated by" box, change the semicolon ';' to a comma ',' then click on Go

You will be notified of any errors that occur in the import process.


Related Articles
Attachments
No attachments were found.

Powered by Interspire Knowledge Manager Knowledgebase Software