insert zones for indonesia ?

[diktusit]

i'm from indonesia. I want to insert city and province in indonesian country how to do that???very long time if i insert 1 by 1. i have the database but with excel format (.xls). please give me a solution???

[whplus]

please download and install indonesia zone (http://www.zen-cart.com/index.php?ma...oducts_id=1104)

susan,

[sukma]

How to add the zone by PhpMyadmin?

[sukma]

please download and install indonesia zone (http://www.zen-cart.com/index.php?ma...oducts_id=1104)

susan,

Dear Susan...
when I imported the file I've got this error message inside my phpmyadmin

SQL query:

INSERT INTO zones( zone_id, zone_country_id, zone_code, zone_name )
VALUES (
'', 100, 'Sumut', 'Sumatera Utara'
);

MySQL said: Documentation
#1062 - Duplicate entry '0' for key 'PRIMARY'

What can do?

[sukma]

please download and install indonesia zone (http://www.zen-cart.com/index.php?ma...oducts_id=1104)

susan,

Dear Susan...
when I imported the file I've got this error message inside my phpmyadmin

SQL query:

INSERT INTO zones( zone_id, zone_country_id, zone_code, zone_name )
VALUES (
'', 100, 'Sumut', 'Sumatera Utara'
);

MySQL said: Documentation
#1062 - Duplicate entry '0' for key 'PRIMARY'

What can i do?