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. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 5, 2007 Share Posted February 5, 2007 What application? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
ItsWesYo Posted February 5, 2007 Author Share Posted February 5, 2007 Nevermind, i got it now. Quote Link to comment 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... Quote Link to comment 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? Quote Link to comment 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.