Trouble exporting .csv to mysql.

[Anon]

Hello, I use phpmyadmin and I asked for help with their support, so far, nothing

I don't need to go to mysql.com for load data infile help as the matter seems to be me not understanding how to import the .csv text file into mysql

If it is an .sql file I can do it without fail

However, my text file is formatted as:

(left field is id, right is 'name')

1,"joel"
2,"dave"
3,"Fred"
4,"Jack"

Ok, so that's what I am importing into a table in mysql called "members"

However, when I import this file

(names.txt)

the ID's are inserted, not the names

Anybody know how to take the access data (Without recommending software) and import this .csv file into mysql without fail? It's not the logic of using load data infile, it's knowing if my format is correct and learning how to recognize why it's failing

So if you use phpmyadmin, how do you do it?

Thanks

[sarahk]

I use phpMyAdmin but have never tried their import tool so can't comment.

I tend to haul the data into excel (or other spreadsheet which can easily read .csv) and in a column have a formula

='insert into mytable (id, name) values ("' & a1 & '","' & a2 & '");'

This then gives me a nice insert statement, and I copy the lot into the little query box and hit go. If I've got it wrong it quickly tells me. The only problem you may have is if you need to addslashes()

HTH