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 72771 Richard Conaway 04/24/2008 11:52PM
Re: Import data from an excel spreadsheet into an mysql database 40587 Michael Markel 07/17/2008 12:03PM
Re: Import data from an excel spreadsheet into an mysql database 17567 Richard Conaway 07/17/2008 01:07PM
Re: Import data from an excel spreadsheet into an mysql database 11846 Mohammad Osman Goni 06/02/2009 08:32AM
Re: Import data from an excel spreadsheet into an mysql database 13494 Toby White-Beebe 08/19/2008 02:49PM
Re: Import data from an excel spreadsheet into an mysql database 9210 murali murali 11/20/2008 02:27PM
Re: Import data from an excel spreadsheet into an mysql database 7777 Richard C 11/21/2008 08:45AM
Re: Import data from an excel spreadsheet into an mysql database 10456 Son Tran 11/23/2008 09:19PM
Import data from an excel spreadsheet into an mysql database 6169 sandeep sandeep 06/21/2009 11:39PM
Import data from an excel spreadsheet into an mysql database 5591 suneel sharma 07/19/2009 02:05AM
Re: Import data from an excel spreadsheet into an mysql database 9185 Jay Alverson 11/23/2008 03:41PM
Re: Import data from an excel spreadsheet into an mysql database 6878 Matthew Adams 12/12/2008 05:13PM
Re: Import data from an excel spreadsheet into an mysql database 6161 Jay Alverson 04/09/2009 08:03AM
Re: Import data from an excel spreadsheet into an mysql database 5651 meenu khanna 04/07/2009 03:01AM
Re: Import data from an excel spreadsheet into an mysql database 6470 Steven Bebsen 06/08/2009 12:51PM
Re: Import data from an excel spreadsheet into an mysql database 6969 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.