Option Explicit Public conn As New ADODB.Connection Public rs As New ADODB.Recordset Private Sub Form_Load() Dim strconn As String strconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;Persist Security Info=False;Jet OLEDB:DataBase Password='123'" conn.CursorLocation = adUseClient conn.Open strconn
If rs.State = 1 Then rs.Close rs.Open "select * from Phone", conn, 3, 3
Set Me.DataGrid1.DataSource = rs End Sub最簡單用adodc控件,然後生成連接字符,然後copy,無論sql還是access還是其它數據庫都能搞定
Public conn As New ADODB.Connection
Public rs As New ADODB.Recordset
Private Sub Form_Load()
Dim strconn As String
strconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\test.mdb;Persist Security Info=False;Jet OLEDB:DataBase Password='123'"
conn.CursorLocation = adUseClient
conn.Open strconn
If rs.State = 1 Then rs.Close
rs.Open "select * from Phone", conn, 3, 3
Set Me.DataGrid1.DataSource = rs
End Sub最簡單用adodc控件,然後生成連接字符,然後copy,無論sql還是access還是其它數據庫都能搞定