Create a Database name = ARCMAP Create a Table name = STATES Help on how to create Table using phpMyAdmin: http://code.google.com/support/bin/answer.py?answer=69906#createtable 12 fields Field names = OBJECTID POP1990 HOUSEHOLDS MALES FEMALES x y NAME alt_10 t_in t_out ICON as defined below. Copy Below for insert data (MyPhpAdmin - SQL Tab) INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('1','4866692','1872431','2413747','2452945','-120.4280275','47.37676195','Washington','486669','0','1','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('2','799065','306163','395769','403296','-109.6525337','47.03226646','Montana','79906','1','2','green'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('3','1227928','465312','597850','630078','-69.23428031','45.38940935','Maine','122793','2','3','green'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('4','638800','240878','318201','320599','-100.470755','47.44607757','NorthDakota','63880','3','4','green'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('5','696004','259034','342498','353506','-100.2352889','44.43331814','SouthDakota','69600','4','5','green'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('6','453588','168839','227007','226581','-107.553081','42.99828376','Wyoming','45359','5','6','green'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('7','4891769','1822118','2392935','2498834','-90.00619123','44.63311789','Wisconsin','489177','6','7','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('8','1006749','360723','500956','505793','-114.6618654','44.38589547','Idaho','100675','7','8','green'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('9','562758','210650','275492','287266','-72.66065624','44.07224059','Vermont','56276','8','9','green'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('10','4375099','1647853','2145183','2229916','-94.30594568','46.31564657','Minnesota','437510','9','10','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('11','2842321','1103313','1397073','1445248','-120.5546274','43.93150955','Oregon','284232','10','11','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('12','1109252','411186','543544','565708','-71.57776959','43.68519103','NewHampshire','110925','11','12','green'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('13','2776755','1064325','1344802','1431953','-93.5010909','42.07598914','Iowa','277676','12','13','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('14','6016425','2247110','2888745','3127680','-71.80258993','42.25683452','Massachusetts','601642','13','14','red'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('15','1578385','602363','769439','808946','-99.8078006','41.52315828','Nebraska','157838','14','15','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('16','17990455','6639322','8625673','9364782','-75.51225742','42.94666083','NewYork','1799046','15','16','red'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('17','11881643','4495966','5694265','6187378','-77.80284542','40.87488906','Pennsylvania','1188164','16','17','red'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('18','3287116','1230479','1592873','1694243','-72.72476998','41.61803266','Connecticut','328712','17','18','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('19','1003464','377977','481496','521968','-71.56104443','41.68177249','RhodeIsland','100346','18','19','green'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('20','7730188','2794711','3735685','3994503','-74.67662778','40.19831303','NewJersey','773019','19','20','red'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('21','5544159','2065355','2688281','2855878','-86.27615732','39.91274012','Indiana','554416','20','21','red'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('22','1201833','466297','611880','589953','-116.6507352','39.3520158','Nevada','120183','21','22','green'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('23','1722850','537273','855759','867091','-111.6760536','39.32251229','Utah','172285','22','23','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('24','29760021','10381206','14897627','14862394','-119.6011471','37.2417411','California','2976002','23','24','red'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('25','10847115','4087546','5226340','5620775','-82.78739067','40.28753542','Ohio','1084712','24','25','red'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('26','11430602','4202240','5552233','5878369','-89.20376783','40.06400017','Illinois','1143060','25','26','red'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('27','606900','249634','282970','323930','-77.01562756','38.90260102','DistrictofColumbia','60690','26','27','green'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('28','666168','247497','322968','343200','-75.50055367','38.99511443','Delaware','66617','27','28','green'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('29','1793477','688557','861536','931941','-80.61405957','38.64121101','WestVirginia','179348','28','29','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('30','4781468','1748991','2318671','2462797','-76.81938527','39.06405554','Maryland','478147','29','30','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('31','3294394','1282489','1631295','1663099','-105.5478573','38.99726315','Colorado','329439','30','31','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('32','3685296','1379782','1785235','1900061','-85.29036642','37.52650357','Kentucky','368530','31','32','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('33','2477574','944726','1214645','1262929','-98.38325723','38.48265747','Kansas','247757','32','33','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('34','6187358','2291830','3033974','3153384','-78.85159444','37.51863556','Virginia','618736','33','34','red'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('35','5117073','1961206','2464315','2652758','-92.48018864','38.36399013','Missouri','511707','34','35','red'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('36','3665228','1368843','1810691','1854537','-111.6645919','34.29168342','Arizona','366523','35','36','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('37','3145585','1206135','1530819','1614766','-97.50945859','35.583978','Oklahoma','314558','36','37','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('38','6628637','2517026','3214290','3414347','-79.40131553','35.54726507','NorthCarolina','662864','37','38','red'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('39','4877185','1853725','2348928','2528257','-86.33406701','35.84670789','Tennessee','487718','38','39','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('40','16986510','6070937','8365963','8620547','-99.35209639','31.49116036','Texas','1698651','39','40','red'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('41','1515069','542709','745253','769816','-106.1024032','34.42341101','NewMexico','151507','40','41','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('42','4040587','1506790','1936162','2104425','-86.82634545','32.79482335','Alabama','404059','41','42','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('43','2573216','911374','1230617','1342599','-89.66400538','32.75916411','Mississippi','257322','42','43','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('44','6478216','2366615','3144503','3333713','-83.45422581','32.65509571','Georgia','647822','43','44','red'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('45','3486703','1258044','1688510','1798193','-80.90102009','33.91874227','SouthCarolina','348670','44','45','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('46','2350725','891179','1133076','1217649','-92.43380149','34.89795308','Arkansas','235072','45','46','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('47','4219973','1499269','2031386','2188587','-92.02915412','31.09573464','Louisiana','421997','46','47','yellow'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('48','12937926','5134869','6261719','6676207','-82.49557414','28.65867646','Florida','1293793','47','48','red'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('49','9295297','3419331','4512781','4782516','-85.43860253','44.33654844','Michigan','929530','48','49','red'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('50','1108229','356267','563891','544338','-156.3298113','20.24332099','Hawaii','110823','49','50','green'); INSERT INTO `STATES`(`OBJECTID`,`POP1990`,`HOUSEHOLDS`,`MALES`,`FEMALES`,`x`,`y`,`NAME`,`alt_10`,`t_in`,`t_out`,`ICON`)VALUES('51','550043','188915','289867','260176','-152.5713081','64.31717179','Alaska','55004','50','51','green');