[SOLVED] PHP Basic Help: Importing CSV file into myPHPadmin?

[webmaster1]

Hi All,

 

I've saved a Vista Excel file as CSV. The default list seperator is a comma.

 

When I load it myPHPadmin I get "Invalid field count in CSV input on line 1".

 

In myPHPadmin I have the following default settings:

 

Fields terminated by:;

Fields enlosed by:"

Fields escaped by:\

Lines terminated by:auto

Column names:

 

Can anyone spot where I'm going wrong? (I remember having more export options in XP)

 

 

 

[bubbasheeko]

Yes, you said the CSV fields are being separated by a comma.  Your PHPMyAdmin configuration shows a semi colon.  That would be the one thing that stands out right now.

[webmaster1]

Thanks, that worked.

 

Any ideas why it imports my field headings (i.e. the first row)

 

Can I prevent that through myPHPadmin ? (any other advice or tips with the import part of the interface would be apreciated at this time)

 

 

[printf]

partial import (check it), enter (1) in the text box "number of records to skip from start"

[webmaster1]

Excellent! Thanks printf and bubbasheeko!