| Sub ADOListTables2() Dim cnn As New ADODB.Connection Dim rst As ADODB.Recordset ' Open the connection cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=.\NorthWind.mdb;" ' Open the tables schema rowset Set rst = cnn.OpenSchema(adSchemaTables) ' Loop through the results and print ' the names in the debug window Do Until rst.EOF If rst.Fields("TABLE_TYPE") <> "VIEW" Then Debug.Print rst.Fields("TABLE_NAME") End If rst.MoveNext Loop End Sub |
Tables, List 2 |
India web developer web development India | Freelance web development ecommerce web developer | Prayagasoft - web designer India, Ecommerce developer india, Ecommerce design