CSV and phpmyadmi?

Sayian

I have a file with zipcode information

zipcode city state
74557 abelie TX

It is in this format for all zipcodes ... the top 3 colums are zipcode , city , state
then the rows are the information

Ive created a table in mysql called zipcodes , with 3 colums , zipcode , city , state

just as the data in the file is arranged

When i click "insert data from textfile" in phpmy admin , its placing all of the data into the first colum "zipcode" then cutting all the rest of it off

is their a simplier way to do this , please note that i DO NOT have access to a command console for mysql.

Im just trying to create a table from the zipcode data .. help please

nemonoman

create a comma separated value (csv) file from your excel spreadsheet...it's a 'save as...' file option in excel.

74557, abelie, TX

then use the CSV upload option in phpMyAdmin

Sayian

Yes , its in CSV , but i cannot find the option in phpmyadmin anywhere to create a table from a csv file

cyberlew15

I think php my admin auto detects the type of seperator used for textfiles. if not i'm sure theres an app that does so if you can't find one plz pm me with ur OS e.g. windows or linux and I'll see what I can do

nemonoman

I just looked at the manual, and while phpMyAdmin WRITES csv files, there is no indication that it READS csv files. However, it wouldn't be hard to write a php script to read the CSV file and turn it into an extended insert, or even to use "find and replace" in a word processor to create an extended insert that could be pasted into phpMyAdmin.

johnnyr55

hey i had the same issue.. make sure u select a file delimiter in phpmyadmin to , because i think it is ; as default.. i think the field to check is field terminated by... if that doesnt work open the csv in notepad and make sure there is no spaces or any other separaters in there and resave it as txt... i have had no problems and all my data comes in fine.. hope that helps

Sayian

Thnaks for all your input and help

I still cannot get phpmyadmin to take the file

See , it wont let you just take a csv file and creatre a table from it. You must create a table first to "import a text file" so i did , I set the table up exactly how its setup in the csv file , and it wont import correctly.

Im a beginner to php scripting , well , should i put it , working with files in php.

I would not have the knowledge to write a script to read files and insert them into a database.

Is their any other way to get a csv file just to create a table based on it's structure ... I mean someone else had to be going thru this same thing at sometime.

johnnyr55

can u send me the text file cuz ive been successfull in uploading the text files... lemme look at yours and ill see what i can do.. send to johnnyr5@bellsouth.net if u dont mind so i can see... thanks