Importing excel spreadsheet into database

[chazzy69]

I trying to import a excel table into a mysql database table. First thing i did was make colums up according to the colum names in the excel table, then i exported the excel document as a .csv file (comma seperated) i then went to my database and imported the excel document;

Thats when i get this error "Invalid field count in CSV input on line 1",
so i open up the .csv file and look at line 1 -

"Pcode,Locality,State,Comments,DeliveryOffice,Pres ortIndicator,ParcelZone,BSPnumber,BSPname,Category "

this is when i realise that the names in the table don't match that in database, so i then change the names so that they are the same -

"PCODE,LOCALITY,STATE,COMMENTS,DELIVERYOF,PRESORTI ND,PARCELZONE,BSPNUMBER,BSPNAME,CATEGORY"

After this i still get the same error, i then see that for the import u can specify the colum names so i do this and again i get the same error.

So what i want to know is how to fix the error???

Thanks in advanced, your help is greatly appreciated.

[code green]

Have you checked and specified which delimiter you are using?
A CSV ought to be comma delimited but could be semi-colon or tab delimited.

[chazzy69]

Ok i have check the .csv file and everything is seperated by commas. I then double checked the options it was specifying for import and noticed that the some of them won't work with this file.

The options that may be wrong:

Fields terminated by :
Fields enclosed by "
Fields enclosed by \
Lines terminated by auto

How should these be if the file im trying to import has only commas and spaces in it??

Thanks for the reply

[chazzy69]

Ok i just figured out how to get it to work i just replaced all the options with commas and left the last option with auto.

Thanks for giving me the right direction to look into

[code green]

It was the 'Fields terminated by : ' causing the problem.
As you can see the default is semi colon.