- ©«¤l
- 76
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 95
- ÂI¦W
- 0
- §@·~¨t²Î
- windowsxp
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2016-8-19
- ³Ì«áµn¿ý
- 2021-5-5
|
¥»©«³Ì«á¥Ñ Changbanana ©ó 2016-9-6 15:12 ½s¿è
¦^´_ 2# lpk187
ÁÂÁ§AªºµªÂÐ
¥Ø«eY¬O¶]¤TÄ檺¸ê®Æ©M³£¦³Èªº¸Ü¬O³£¦³½Æ»s¹L¥h
¦ý¦³µo²{Y¬O¤¤¶¡¦³ªÅ¸ê®Æ´NµLªk°µ¤F
¥i¥H§âkeyȧ令ID¶Ü?
ÁÙ¦³¼W¥[Äæ¦ìªº¸Ü¬O¤£¬O³o¼Ë°µ?- Public Sub ¶×¥X()
- Dim arr, i%
- Dim myCon As Object, myRs As Object, sql$
- Set myCon = CreateObject("ADODB.Connection")
- Set myRs = CreateObject("ADODB.Recordset")
- myCon.Open "provider=Microsoft.ACE.OLEDB.12.0;" & "Data Source=" & ThisWorkbook.Path & "\test.accdb;"
- arr = Sheets(1).Range("[color=Red]D1[/color]", Sheets(1).[A65535].End(xlUp))
- Set myRs = Nothing
- For i = 1 To UBound(arr)
- sql = "SELECT * FROM ¸ê®Æªí1 WHERE ¸ê®Æªí1.¦WºÙ Like '" & arr(i, 1) & "';"
- Set myRs = myCon.Execute(sql)
- If myRs.EOF = True Then
- sql = "INSERT INTO " & "¸ê®Æªí1" & "(¦WºÙ,ID,¦¨ÁZ°ê,[color=Red]¦¨ÁZ¼Æ[/color])" & _
- " VALUES('" & arr(i, 1) & "','" & arr(i, 2) & "','" & arr(i, 3) & "'[color=Red]," & arr(i, 4) & "[/color]);"
- Set myRs = myCon.Execute(sql)
- End If
- Set myRs = Nothing
- Next
- Set myRs = Nothing
- myCon.Close
- Set myCon = Nothing
- End Sub
½Æ»s¥N½X ¦¨ÁZ¼Æ¬O·Qn¼W¥[Äæ¦ìªº¸ê®Æ~ |
|