creating a table with this csv data

[ricez]

Hey everyone,

 

I am trying to add this file into a MySQL table and it is not working out as predicted.

 

I want to have the database field to be:

 

ZIP, LATITUDE, LONGITUDE, CITY, STATE, COUNTY, ZIP_CLASS

 

Here are the first few lines from the text file:

 

"00501","+40.922326","-072.637078","HOLTSVILLE","NY","SUFFOLK","UNIQUE"

"00544","+40.922326","-072.637078","HOLTSVILLE","NY","SUFFOLK","UNIQUE"

"00601","+18.165273","-066.722583","ADJUNTAS","PR","ADJUNTAS","STANDARD"

"00602","+18.393103","-067.180953","AGUADA","PR","AGUADA","STANDARD"

"00603","+18.455913","-067.145780","AGUADILLA","PR","AGUADILLA","STANDARD"

"00604","+18.493520","-067.135883","AGUADILLA","PR","AGUADILLA","STANDARD"

"00605","+18.465162","-067.141486","AGUADILLA","PR","AGUADILLA","STANDARD"

"00606","+18.172947","-066.944111","MARICAO","PR","MARICAO","STANDARD"

 

I tried using this and it didn't fan out as predicted with the use of PHPMyAdmin. Any help with this is appreciated.

[hvle]

you need to write a script, this script read each row, parse the csv into single field then insert into database.  Sound complicated but could easily be written in PHP.

[ricez]

Cool. Thank you.

 

By the way, what is wrong with PHPMYAdmin when it comes to importing csv?