PDA

View Full Version : Error Excel to MySQL


sal311595
01-19-2010, 06:55 PM
Hello, I am new in this forum.

Trying to upload a file that I convert to mysql and I get the folllowing error in my server:

Error
SQL:

default - character - SET = latin1default - COLLATION = latin1_swedish_ci

MySQL :

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'default-character-set=latin1
default-collation=latin1_swedish_ci' at line 1

How Can I import it to my server ????

Thank you in advance

Sal

clifford
01-20-2010, 06:57 AM
Verify that this database was created as 'character-set=latin1 default-collation=latin1_swedish_ci' if not you may have a conflict there.