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 72893 Richard Conaway 04/24/2008 11:52PM
Re: Import data from an excel spreadsheet into an mysql database 40700 Michael Markel 07/17/2008 12:03PM
Re: Import data from an excel spreadsheet into an mysql database 17609 Richard Conaway 07/17/2008 01:07PM
Re: Import data from an excel spreadsheet into an mysql database 11881 Mohammad Osman Goni 06/02/2009 08:32AM
Re: Import data from an excel spreadsheet into an mysql database 13522 Toby White-Beebe 08/19/2008 02:49PM
Re: Import data from an excel spreadsheet into an mysql database 9244 murali murali 11/20/2008 02:27PM
Re: Import data from an excel spreadsheet into an mysql database 7805 Richard C 11/21/2008 08:45AM
Re: Import data from an excel spreadsheet into an mysql database 10503 Son Tran 11/23/2008 09:19PM
Import data from an excel spreadsheet into an mysql database 6199 sandeep sandeep 06/21/2009 11:39PM
Import data from an excel spreadsheet into an mysql database 5613 suneel sharma 07/19/2009 02:05AM
Re: Import data from an excel spreadsheet into an mysql database 9217 Jay Alverson 11/23/2008 03:41PM
Re: Import data from an excel spreadsheet into an mysql database 6912 Matthew Adams 12/12/2008 05:13PM
Re: Import data from an excel spreadsheet into an mysql database 6197 Jay Alverson 04/09/2009 08:03AM
Re: Import data from an excel spreadsheet into an mysql database 5684 meenu khanna 04/07/2009 03:01AM
Re: Import data from an excel spreadsheet into an mysql database 6502 Steven Bebsen 06/08/2009 12:51PM
Re: Import data from an excel spreadsheet into an mysql database 7006 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.