Skip navigation links

MySQL Forums :: Microsoft Access :: Import data from an excel spreadsheet into an mysql database


Advanced Search

Import data from an excel spreadsheet into an mysql database
Posted by: Richard Conaway ()
Date: April 24, 2008 11:52PM

Hello

This question is not about access but about excel.

I want to import data from an excel spreadsheet into an mysql database and I also have an access database as well to work with the same information.

I am trying to import an excel .csv file into mysql using phpmyadmin.

I get an error saying...

"Invalid field count in CSV input on line 1."

I have tried to make everything as similar as possible and the fields are the same.

I do have a primary ID key which is blank on the excel file, could that be messing things up?

Thank you for any help.

Options: ReplyQuote


Subject Views Written By Posted
Import data from an excel spreadsheet into an mysql database 72143 Richard Conaway 04/24/2008 11:52PM
Re: Import data from an excel spreadsheet into an mysql database 40090 Michael Markel 07/17/2008 12:03PM
Re: Import data from an excel spreadsheet into an mysql database 17434 Richard Conaway 07/17/2008 01:07PM
Re: Import data from an excel spreadsheet into an mysql database 11729 Mohammad Osman Goni 06/02/2009 08:32AM
Re: Import data from an excel spreadsheet into an mysql database 13396 Toby White-Beebe 08/19/2008 02:49PM
Re: Import data from an excel spreadsheet into an mysql database 9077 murali murali 11/20/2008 02:27PM
Re: Import data from an excel spreadsheet into an mysql database 7697 Richard C 11/21/2008 08:45AM
Re: Import data from an excel spreadsheet into an mysql database 10266 Son Tran 11/23/2008 09:19PM
Import data from an excel spreadsheet into an mysql database 6075 sandeep sandeep 06/21/2009 11:39PM
Import data from an excel spreadsheet into an mysql database 5467 suneel sharma 07/19/2009 02:05AM
Re: Import data from an excel spreadsheet into an mysql database 9062 Jay Alverson 11/23/2008 03:41PM
Re: Import data from an excel spreadsheet into an mysql database 6771 Matthew Adams 12/12/2008 05:13PM
Re: Import data from an excel spreadsheet into an mysql database 6051 Jay Alverson 04/09/2009 08:03AM
Re: Import data from an excel spreadsheet into an mysql database 5563 meenu khanna 04/07/2009 03:01AM
Re: Import data from an excel spreadsheet into an mysql database 6347 Steven Bebsen 06/08/2009 12:51PM
Re: Import data from an excel spreadsheet into an mysql database 6860 Jay Alverson 06/22/2009 07:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.