Attribute VB_Name = "Module1"
Public Type HZType
    HanZi As String
    PingYin As String
End Type
Public HanZiArrary(1 To 6825) As HZType


Public Sub main()
    LoadData
    Dim i As Integer
    Dim strCn As String
    strCn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=employee;Data Source=LENOVO-E83C9718"
    Dim myRS As New ADODB.Recordset
    myRS.Open "select * from hanzipy", strCn, adOpenDynamic, adLockOptimistic
    
    
    For i = 1 To 6825
        myRS.AddNew
            myRS!HanZi = HanZiArrary(i).HanZi
            myRS!PingYin = HanZiArrary(i).PingYin
        myRS.Update
    Next i
    myRS.Close
    MsgBox "OK"
    End Sub

Public Sub LoadData()
    LoadPinYin
    LoadPinYin1
    LoadPinYin2
    LoadPinYin3
    LoadPinYin4
    LoadPinYin5
    LoadPinYin6
End Sub

Public Sub LoadPinYin1()
    HanZiArrary(1).HanZi = "啊"
    HanZiArrary(1).PingYin = "a"
    HanZiArrary(2).HanZi = "阿"
    HanZiArrary(2).PingYin = "a"
    HanZiArrary(3).HanZi = "埃"
    HanZiArrary(3).PingYin = "ai"
    HanZiArrary(4).HanZi = "挨"
    HanZiArrary(4).PingYin = "ai"
    HanZiArrary(5).HanZi = "哎"
    HanZiArrary(5).PingYin = "ai"
    HanZiArrary(6).HanZi = "唉"
    HanZiArrary(6).PingYin = "ai"
    HanZiArrary(7).HanZi = "哀"
    HanZiArrary(7).PingYin = "ai"
    HanZiArrary(8).HanZi = "皚"
    HanZiArrary(8).PingYin = "ai"
    HanZiArrary(9).HanZi = "癌"
    HanZiArrary(9).PingYin = "ai"
    HanZiArrary(10).HanZi = "藹"
    HanZiArrary(10).PingYin = "ai"
    HanZiArrary(11).HanZi = "矮"
    HanZiArrary(11).PingYin = "ai"
    HanZiArrary(12).HanZi = "艾"
    HanZiArrary(12).PingYin = "ai"
    HanZiArrary(13).HanZi = "礙"
    HanZiArrary(13).PingYin = "ai"
    HanZiArrary(14).HanZi = "愛"
    HanZiArrary(14).PingYin = "ai"
    HanZiArrary(15).HanZi = "隘"
    HanZiArrary(15).PingYin = "ai"
    HanZiArrary(16).HanZi = "鞍"
    HanZiArrary(16).PingYin = "an"
    HanZiArrary(17).HanZi = "氨"
    HanZiArrary(17).PingYin = "an"
    HanZiArrary(18).HanZi = "安"
    HanZiArrary(18).PingYin = "an"
    HanZiArrary(19).HanZi = "俺"
    HanZiArrary(19).PingYin = "an"
    HanZiArrary(20).HanZi = "按"
    HanZiArrary(20).PingYin = "an"
    HanZiArrary(21).HanZi = "暗"
    HanZiArrary(21).PingYin = "an"
    HanZiArrary(22).HanZi = "岸"
    HanZiArrary(22).PingYin = "an"
    HanZiArrary(23).HanZi = "胺"
    HanZiArrary(23).PingYin = "an"
    HanZiArrary(24).HanZi = "案"
    HanZiArrary(24).PingYin = "an"
    HanZiArrary(25).HanZi = "骯"
    HanZiArrary(25).PingYin = "ang"
    HanZiArrary(26).HanZi = "昂"
    HanZiArrary(26).PingYin = "ang"
    HanZiArrary(27).HanZi = "盎"
    HanZiArrary(27).PingYin = "ang"
    HanZiArrary(28).HanZi = "凹"
    HanZiArrary(28).PingYin = "ao"
    HanZiArrary(29).HanZi = "敖"
    HanZiArrary(29).PingYin = "ao"
    HanZiArrary(30).HanZi = "熬"
    HanZiArrary(30).PingYin = "ao"
    HanZiArrary(31).HanZi = "翱"
    HanZiArrary(31).PingYin = "ao"
    HanZiArrary(32).HanZi = "襖"
    HanZiArrary(32).PingYin = "ao"
    HanZiArrary(33).HanZi = "傲"
    HanZiArrary(33).PingYin = "ao"
    HanZiArrary(34).HanZi = "奧"
    HanZiArrary(34).PingYin = "ao"
    HanZiArrary(35).HanZi = "懊"
    HanZiArrary(35).PingYin = "ao"
    HanZiArrary(36).HanZi = "澳"
    HanZiArrary(36).PingYin = "ao"
    HanZiArrary(37).HanZi = "芭"
    HanZiArrary(37).PingYin = "ba"
    HanZiArrary(38).HanZi = "捌"
    HanZiArrary(38).PingYin = "ba"
    HanZiArrary(39).HanZi = "扒"
    HanZiArrary(39).PingYin = "pa"
    HanZiArrary(40).HanZi = "叭"
    HanZiArrary(40).PingYin = "ba"
    HanZiArrary(41).HanZi = "吧"
    HanZiArrary(41).PingYin = "ba"
    HanZiArrary(42).HanZi = "笆"
    HanZiArrary(42).PingYin = "ba"
    HanZiArrary(43).HanZi = "八"
    HanZiArrary(43).PingYin = "ba"
    HanZiArrary(44).HanZi = "疤"
    HanZiArrary(44).PingYin = "ba"
    HanZiArrary(45).HanZi = "巴"
    HanZiArrary(45).PingYin = "ba"
    HanZiArrary(46).HanZi = "拔"
    HanZiArrary(46).PingYin = "ba"
    HanZiArrary(47).HanZi = "跋"
    HanZiArrary(47).PingYin = "ba"
    HanZiArrary(48).HanZi = "靶"
    HanZiArrary(48).PingYin = "ba"
    HanZiArrary(49).HanZi = "把"
    HanZiArrary(49).PingYin = "ba"
    HanZiArrary(50).HanZi = "耙"
    HanZiArrary(50).PingYin = "ba"
    HanZiArrary(51).HanZi = "耙"
    HanZiArrary(51).PingYin = "pa"
    HanZiArrary(52).HanZi = "壩"
    HanZiArrary(52).PingYin = "ba"
    HanZiArrary(53).HanZi = "霸"
    HanZiArrary(53).PingYin = "ba"
    HanZiArrary(54).HanZi = "罷"
    HanZiArrary(54).PingYin = "ba"
    HanZiArrary(55).HanZi = "爸"
    HanZiArrary(55).PingYin = "ba"
    HanZiArrary(56).HanZi = "白"
    HanZiArrary(56).PingYin = "bai"
    HanZiArrary(57).HanZi = "柏"
    HanZiArrary(57).PingYin = "bai"
    HanZiArrary(58).HanZi = "百"
    HanZiArrary(58).PingYin = "bai"
    HanZiArrary(59).HanZi = "擺"
    HanZiArrary(59).PingYin = "bai"
    HanZiArrary(60).HanZi = "佰"
    HanZiArrary(60).PingYin = "bai"
    HanZiArrary(61).HanZi = "敗"
    HanZiArrary(61).PingYin = "bai"
    HanZiArrary(62).HanZi = "拜"
    HanZiArrary(62).PingYin = "bai"
    HanZiArrary(63).HanZi = "稗"
    HanZiArrary(63).PingYin = "bai"
    HanZiArrary(64).HanZi = "斑"
    HanZiArrary(64).PingYin = "ban"
    HanZiArrary(65).HanZi = "班"
    HanZiArrary(65).PingYin = "ban"
    HanZiArrary(66).HanZi = "搬"
    HanZiArrary(66).PingYin = "ban"
    HanZiArrary(67).HanZi = "扳"
    HanZiArrary(67).PingYin = "ban"
    HanZiArrary(68).HanZi = "般"
    HanZiArrary(68).PingYin = "ban"
    HanZiArrary(69).HanZi = "頒"
    HanZiArrary(69).PingYin = "ban"
    HanZiArrary(70).HanZi = "板"
    HanZiArrary(70).PingYin = "ban"
    HanZiArrary(71).HanZi = "版"
    HanZiArrary(71).PingYin = "ban"
    HanZiArrary(72).HanZi = "扮"
    HanZiArrary(72).PingYin = "ban"
    HanZiArrary(73).HanZi = "拌"
    HanZiArrary(73).PingYin = "ban"
    HanZiArrary(74).HanZi = "伴"
    HanZiArrary(74).PingYin = "ban"
    HanZiArrary(75).HanZi = "瓣"
    HanZiArrary(75).PingYin = "ban"
    HanZiArrary(76).HanZi = "半"
    HanZiArrary(76).PingYin = "ban"
    HanZiArrary(77).HanZi = "辦"
    HanZiArrary(77).PingYin = "ban"
    HanZiArrary(78).HanZi = "絆"
    HanZiArrary(78).PingYin = "ban"
    HanZiArrary(79).HanZi = "邦"
    HanZiArrary(79).PingYin = "bang"
    HanZiArrary(80).HanZi = "幫"
    HanZiArrary(80).PingYin = "bang"
    HanZiArrary(81).HanZi = "梆"
    HanZiArrary(81).PingYin = "bang"
    HanZiArrary(82).HanZi = "榜"
    HanZiArrary(82).PingYin = "bang"
    HanZiArrary(83).HanZi = "膀"
    HanZiArrary(83).PingYin = "bang"
    HanZiArrary(84).HanZi = "綁"
    HanZiArrary(84).PingYin = "bang"
    HanZiArrary(85).HanZi = "棒"
    HanZiArrary(85).PingYin = "bang"
    HanZiArrary(86).HanZi = "磅"
    HanZiArrary(86).PingYin = "bang"
    HanZiArrary(87).HanZi = "蚌"
    HanZiArrary(87).PingYin = "bang"
    HanZiArrary(88).HanZi = "鎊"
    HanZiArrary(88).PingYin = "bang"
    HanZiArrary(89).HanZi = "傍"
    HanZiArrary(89).PingYin = "bang"
    HanZiArrary(90).HanZi = "謗"
    HanZiArrary(90).PingYin = "bang"
    HanZiArrary(91).HanZi = "苞"
    HanZiArrary(91).PingYin = "bao"
    HanZiArrary(92).HanZi = "胞"
    HanZiArrary(92).PingYin = "bao"
    HanZiArrary(93).HanZi = "包"
    HanZiArrary(93).PingYin = "bao"
    HanZiArrary(94).HanZi = "褒"
    HanZiArrary(94).PingYin = "bao"
    HanZiArrary(95).HanZi = "剝"
    HanZiArrary(95).PingYin = "bo"
    HanZiArrary(96).HanZi = "薄"
    HanZiArrary(96).PingYin = "bao"
    HanZiArrary(97).HanZi = "雹"
    HanZiArrary(97).PingYin = "bao"
    HanZiArrary(98).HanZi = "保"
    HanZiArrary(98).PingYin = "bao"
    HanZiArrary(99).HanZi = "堡"
    HanZiArrary(99).PingYin = "bao"
    HanZiArrary(100).HanZi = "飽"
    HanZiArrary(100).PingYin = "bao"
    HanZiArrary(101).HanZi = "寶"
    HanZiArrary(101).PingYin = "bao"
    HanZiArrary(102).HanZi = "抱"
    HanZiArrary(102).PingYin = "bao"
    HanZiArrary(103).HanZi = "報"
    HanZiArrary(103).PingYin = "bao"
    HanZiArrary(104).HanZi = "暴"
    HanZiArrary(104).PingYin = "bao"
    HanZiArrary(105).HanZi = "豹"
    HanZiArrary(105).PingYin = "bao"
    HanZiArrary(106).HanZi = "鮑"
    HanZiArrary(106).PingYin = "bao"
    HanZiArrary(107).HanZi = "爆"
    HanZiArrary(107).PingYin = "bao"
    HanZiArrary(108).HanZi = "杯"
    HanZiArrary(108).PingYin = "bei"
    HanZiArrary(109).HanZi = "碑"
    HanZiArrary(109).PingYin = "bei"
    HanZiArrary(110).HanZi = "悲"
    HanZiArrary(110).PingYin = "bei"
    HanZiArrary(111).HanZi = "卑"
    HanZiArrary(111).PingYin = "bei"
    HanZiArrary(112).HanZi = "北"
    HanZiArrary(112).PingYin = "bei"
    HanZiArrary(113).HanZi = "輩"
    HanZiArrary(113).PingYin = "bei"
    HanZiArrary(114).HanZi = "背"
    HanZiArrary(114).PingYin = "bei"
    HanZiArrary(115).HanZi = "貝"
    HanZiArrary(115).PingYin = "bei"
    HanZiArrary(116).HanZi = "鋇"
    HanZiArrary(116).PingYin = "bei"
    HanZiArrary(117).HanZi = "倍"
    HanZiArrary(117).PingYin = "bei"
    HanZiArrary(118).HanZi = "狽"
    HanZiArrary(118).PingYin = "bei"
    HanZiArrary(119).HanZi = "備"
    HanZiArrary(119).PingYin = "bei"
    HanZiArrary(120).HanZi = "憊"
    HanZiArrary(120).PingYin = "bei"
    HanZiArrary(121).HanZi = "焙"
    HanZiArrary(121).PingYin = "bei"
    HanZiArrary(122).HanZi = "被"
    HanZiArrary(122).PingYin = "bei"
    HanZiArrary(123).HanZi = "奔"
    HanZiArrary(123).PingYin = "ben"
    HanZiArrary(124).HanZi = "苯"
    HanZiArrary(124).PingYin = "ben"
    HanZiArrary(125).HanZi = "本"
    HanZiArrary(125).PingYin = "ben"
    HanZiArrary(126).HanZi = "笨"
    HanZiArrary(126).PingYin = "ben"
    HanZiArrary(127).HanZi = "崩"
    HanZiArrary(127).PingYin = "beng"
    HanZiArrary(128).HanZi = "繃"
    HanZiArrary(128).PingYin = "beng"
    HanZiArrary(129).HanZi = "甭"
    HanZiArrary(129).PingYin = "beng"
    HanZiArrary(130).HanZi = "泵"
    HanZiArrary(130).PingYin = "beng"
    HanZiArrary(131).HanZi = "蹦"
    HanZiArrary(131).PingYin = "beng"
    HanZiArrary(132).HanZi = "迸"
    HanZiArrary(132).PingYin = "beng"
    HanZiArrary(133).HanZi = "逼"
    HanZiArrary(133).PingYin = "bi"
    HanZiArrary(134).HanZi = "鼻"
    HanZiArrary(134).PingYin = "bi"
    HanZiArrary(135).HanZi = "比"
    HanZiArrary(135).PingYin = "bi"
    HanZiArrary(136).HanZi = "鄙"
    HanZiArrary(136).PingYin = "bi"
    HanZiArrary(137).HanZi = "筆"
    HanZiArrary(137).PingYin = "bi"
    HanZiArrary(138).HanZi = "彼"
    HanZiArrary(138).PingYin = "bi"
    HanZiArrary(139).HanZi = "碧"
    HanZiArrary(139).PingYin = "bi"
    HanZiArrary(140).HanZi = "蓖"
    HanZiArrary(140).PingYin = "bi"
    HanZiArrary(141).HanZi = "蔽"
    HanZiArrary(141).PingYin = "bi"
    HanZiArrary(142).HanZi = "畢"
    HanZiArrary(142).PingYin = "bi"
    HanZiArrary(143).HanZi = "斃"
    HanZiArrary(143).PingYin = "bi"
    HanZiArrary(144).HanZi = "毖"
    HanZiArrary(144).PingYin = "bi"
    HanZiArrary(145).HanZi = "幣"
    HanZiArrary(145).PingYin = "bi"
    HanZiArrary(146).HanZi = "庇"
    HanZiArrary(146).PingYin = "bi"
    HanZiArrary(147).HanZi = "痹"
    HanZiArrary(147).PingYin = "bi"
    HanZiArrary(148).HanZi = "閉"
    HanZiArrary(148).PingYin = "bi"
    HanZiArrary(149).HanZi = "敝"
    HanZiArrary(149).PingYin = "bi"
    HanZiArrary(150).HanZi = "弊"
    HanZiArrary(150).PingYin = "bi"
    HanZiArrary(151).HanZi = "必"
    HanZiArrary(151).PingYin = "bi"
    HanZiArrary(152).HanZi = "辟"
    HanZiArrary(152).PingYin = "bi"
    HanZiArrary(153).HanZi = "壁"
    HanZiArrary(153).PingYin = "bi"
    HanZiArrary(154).HanZi = "臂"
    HanZiArrary(154).PingYin = "bi"
    HanZiArrary(155).HanZi = "避"
    HanZiArrary(155).PingYin = "bi"
    HanZiArrary(156).HanZi = "陛"
    HanZiArrary(156).PingYin = "bi"
    HanZiArrary(157).HanZi = "鞭"
    HanZiArrary(157).PingYin = "bian"
    HanZiArrary(158).HanZi = "邊"
    HanZiArrary(158).PingYin = "bian"
    HanZiArrary(159).HanZi = "編"
    HanZiArrary(159).PingYin = "bian"
    HanZiArrary(160).HanZi = "貶"
    HanZiArrary(160).PingYin = "bian"