inserting records in phpmyadmin?

[tres]

hello all,

i have a big list of items that i want to insert into my mysql database on my site

i can format the xls so that each row has the appropriate fields

but how do i insert it into the database? which format to save in?

any help would be great, thank you

 

[tres]

1,300 records!

oh, so i can just export my xls into csv you think?

 

[tres]

Ok, managed to get everything set up, but when i import:

Error
Invalid parameter for CSV import: Fields escaped by

What options to I need??



I'm doing fields terminated by ,

i've left the others empty, because i can't use the default for other options (such as " and \) because they're present in some of my data i'm imported and i thought it might wreck everything