ItsWesYo Posted February 5, 2007 Share Posted February 5, 2007 I want to important a .csv file that contains about 75 items in it. Basically, the file looks like this: "id number", "item name", "description of item", "shop it restocks in" Remember, there are about 75 lines of those, only filled with the actual name and such. Anyway, when I import it into mysql: a) I go to 'import' b) I browse for the document c) I choose "csv" for file import file type d) And I click 'go' Only an error shows up and says: Invalid field count in CSV input on line 1. Link to comment https://forums.phpfreaks.com/topic/37171-solved-adding-multiple-items-xls/ Share on other sites More sharing options...
fenway Posted February 5, 2007 Share Posted February 5, 2007 What application? Link to comment https://forums.phpfreaks.com/topic/37171-solved-adding-multiple-items-xls/#findComment-177547 Share on other sites More sharing options...
ItsWesYo Posted February 5, 2007 Author Share Posted February 5, 2007 Spreadsheet. I used it before it do this and it worked perfectly. Link to comment https://forums.phpfreaks.com/topic/37171-solved-adding-multiple-items-xls/#findComment-177557 Share on other sites More sharing options...
ItsWesYo Posted February 5, 2007 Author Share Posted February 5, 2007 Nevermind, i got it now. Link to comment https://forums.phpfreaks.com/topic/37171-solved-adding-multiple-items-xls/#findComment-177603 Share on other sites More sharing options...
fenway Posted February 5, 2007 Share Posted February 5, 2007 Glad you got it working, but this clearly wasn't a MySQL issue... Link to comment https://forums.phpfreaks.com/topic/37171-solved-adding-multiple-items-xls/#findComment-177731 Share on other sites More sharing options...
cavey5 Posted August 27, 2007 Share Posted August 27, 2007 what was the problem? I am having the same issue, solution? Link to comment https://forums.phpfreaks.com/topic/37171-solved-adding-multiple-items-xls/#findComment-334828 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.