Jump to content

Import a CSV file to MySQL ver 5


williejoe

Recommended Posts

This is my first post and am happy I found this forum.  I may have already answered my own question, but thought I would check with the experts.  I am trying to import an Excel CSV file into my MySQL database.  I got several error messages, but now it seems to have worked.  Here is what I did:

 

Using PHPMyAdmin for my table, I selected Structure and at the very bottom is a link to insert a file.  When I select it, I enter the CSV file name.  I had to put a comma into the "fields terminated by" box since my file is a CSV file.  Then I entered all my colums in that box and hit "submit".  The part that was giving my trouble was that I needed the column names at the top of my CSV spreadsheet.  Once I did that, it was easy.  Did I do this right?

Link to comment
https://forums.phpfreaks.com/topic/81032-import-a-csv-file-to-mysql-ver-5/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.