Importing Excel CSV files via PHPMyAdmin

[shelbali]

Hi,

I'm having intermittent problems importing data into my MySQL database via PHPMyAdmin. Sometimes it works and othertimes it appears to work but when I check the imported data, it shows rows of odd symbols like these:
ÐÏࡱá>þÿ 
... ##0;-"£"# ##0"£"# ##0;[Red]-"£"# 0000-00-00

Can anyone tell me what's wrong? I can populate my tables manually but that's defeating the object of what I'm trying to do. I'm new to this so please speak in layman's terms.

I have tried using the CSV, CSV load data option, and I always use the fields terminated by ,

Thanks for any advice

[degsy]

Does the text show up ok in the CSV?
What language/character set are you using in phpMyAdmin?

[shelbali]

Hi,

It shows up in Excel but without any grid lines but in perfect English. I'm using the default setting of language/character set, which I believe is Latin_Swedish ci. Should that be changed from default?
Thanks
Alison

[degsy]

Could you post an example file?

[shelbali]

I've managed to sort this now. Many thanks for the offer of help. My database language wasn't set the same as my table language and I think it was causing a conflict. Thanks anyway :o)

[degsy]

Thanks for the update :)