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 73220 Richard Conaway 04/24/2008 11:52PM
Re: Import data from an excel spreadsheet into an mysql database 41143 Michael Markel 07/17/2008 12:03PM
Re: Import data from an excel spreadsheet into an mysql database 17726 Richard Conaway 07/17/2008 01:07PM
Re: Import data from an excel spreadsheet into an mysql database 12023 Mohammad Osman Goni 06/02/2009 08:32AM
Re: Import data from an excel spreadsheet into an mysql database 13630 Toby White-Beebe 08/19/2008 02:49PM
Re: Import data from an excel spreadsheet into an mysql database 9359 murali murali 11/20/2008 02:27PM
Re: Import data from an excel spreadsheet into an mysql database 7901 Richard C 11/21/2008 08:45AM
Re: Import data from an excel spreadsheet into an mysql database 10634 Son Tran 11/23/2008 09:19PM
Import data from an excel spreadsheet into an mysql database 6315 sandeep sandeep 06/21/2009 11:39PM
Import data from an excel spreadsheet into an mysql database 5704 suneel sharma 07/19/2009 02:05AM
Re: Import data from an excel spreadsheet into an mysql database 9309 Jay Alverson 11/23/2008 03:41PM
Re: Import data from an excel spreadsheet into an mysql database 7028 Matthew Adams 12/12/2008 05:13PM
Re: Import data from an excel spreadsheet into an mysql database 6292 Jay Alverson 04/09/2009 08:03AM
Re: Import data from an excel spreadsheet into an mysql database 5754 meenu khanna 04/07/2009 03:01AM
Re: Import data from an excel spreadsheet into an mysql database 6628 Steven Bebsen 06/08/2009 12:51PM
Re: Import data from an excel spreadsheet into an mysql database 7136 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.