williejoe Posted December 10, 2007 Share Posted December 10, 2007 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? Quote Link to comment https://forums.phpfreaks.com/topic/81032-import-a-csv-file-to-mysql-ver-5/ Share on other sites More sharing options...
fenway Posted December 10, 2007 Share Posted December 10, 2007 Welcome to the forum! Sounds about right... I'm not too familiar with the phpmyadmin interface. Quote Link to comment https://forums.phpfreaks.com/topic/81032-import-a-csv-file-to-mysql-ver-5/#findComment-411149 Share on other sites More sharing options...
mysty Posted December 12, 2007 Share Posted December 12, 2007 I just did this very thing. Looks good, except you need to remove the column names from the spreadsheet otherwise you will end up with a row with those values. Quote Link to comment https://forums.phpfreaks.com/topic/81032-import-a-csv-file-to-mysql-ver-5/#findComment-412764 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.