'引用微软 ADO Ext.2.6 for dll and Security Private Sub Command1_Click()Dim cat As ADOX.Catalog Dim cnn As ADODB.Connection Dim tbl As ADOX.Table Set cat = New ADOX.Catalog Set cnn = New ADODB.Connectioncnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\csdn_vb\查看表名\article.mdb"Set cat.ActiveConnection = cnnOn Error Resume Next'Set tbl = cat.Tables("MyTable") For Each tbl In cat.Tables If Left(tbl.Name, 4) <> "MSys" Then List1.AddItem tbl.Name End If NextSet cat = NothingSet con = NothingEnd Sub
Private Sub Command1_Click()Dim cat As ADOX.Catalog
Dim cnn As ADODB.Connection
Dim tbl As ADOX.Table
Set cat = New ADOX.Catalog
Set cnn = New ADODB.Connectioncnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\csdn_vb\查看表名\article.mdb"Set cat.ActiveConnection = cnnOn Error Resume Next'Set tbl = cat.Tables("MyTable")
For Each tbl In cat.Tables
If Left(tbl.Name, 4) <> "MSys" Then
List1.AddItem tbl.Name
End If
NextSet cat = NothingSet con = NothingEnd Sub