- ©«¤l
- 976
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 1018
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-4-19
- ³Ì«áµn¿ý
- 2024-4-29
|
¦^´_ 1# wsx1130
1.¦pªG·Qn´M§ä³ø¤u¤é´Á°Ï¶¡¡A©Î¬O©Ò¦³¸ê®Æ¦P®É¤U¸ü¡A±ø¥ón¦p¦ó¤U
>>½Ð´ú¸Õ¬Ý¬Ý¡AÁÂÁÂ
Sub test()
Dim conn As New ADODB.Connection
conn.Open "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=D:\database-test.mdb"
Sheets(3).Range("a1").CopyFromRecordset conn.Execute("select * from [DailyReport43600]")
conn.Close
End Sub |
|