Set db = OpenDatabase(Cmdlg.filename)
Adodc1.ConnectionString = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Cmdlg.filename & ";Persist Security Info=False"
Adodc1.RecordSource = "sjjg"
Set DataGrid1.DataSource = Adodc1
在上面的语句中 我写了一个已知的特定表 能否把adodc1.recordsource="sjjg"这句话的sjjg表设成任意表呀 如cmdlg.filename之类的可变变量
因为上面是我写在"打开数据表"中的按钮里的内容!我有急用 谢谢帮忙!
Adodc1.ConnectionString = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Cmdlg.filename & ";Persist Security Info=False"
Adodc1.RecordSource = "sjjg"
Set DataGrid1.DataSource = Adodc1
在上面的语句中 我写了一个已知的特定表 能否把adodc1.recordsource="sjjg"这句话的sjjg表设成任意表呀 如cmdlg.filename之类的可变变量
因为上面是我写在"打开数据表"中的按钮里的内容!我有急用 谢谢帮忙!
dim rs as new adodb.recordset
cn.connectionstring=" Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Cmdlg.filename & ";Persist Security Info=False"
cn.open
rs.activeconnection=cn
rs.CursorType=adOpenStatic
rs.source=text1.text
rs.open
Set DataGrid1.DataSource = rs
Access不行
SQL Server 2000我常这样用哈
Dim conn As New ADODB.Connection
Dim rst As New ADODB.Recordset
conn.Open "dsn=a"
Set rst = conn.OpenSchema(adSchemaTables)
'For i = 0 To rst.Fields.Count - 1
' Debug.Print rst.Fields(i).Name
'Next
Do While Not rst.EOF
Debug.Print rst.Fields("table_name")
rst.MoveNext
Loop