Re: Use pyodbc to count and list tables, columns, indexes, etc

2016-03-31 Thread DFS
On 3/31/2016 11:44 PM, DFS wrote: import pyodbc dbName = "D:\test_data.mdb" conn = pyodbc.connect('DRIVER={Microsoft Access Driver (*.mdb)};DBQ='+dbName) cursor = conn.cursor() #COUNT TABLES, LIST COLUMNS tblCount = 0 for rows in

Use pyodbc to count and list tables, columns, indexes, etc

2016-03-31 Thread DFS
import pyodbc dbName = "D:\test_data.mdb" conn = pyodbc.connect('DRIVER={Microsoft Access Driver (*.mdb)};DBQ='+dbName) cursor = conn.cursor() #COUNT TABLES, LIST COLUMNS tblCount = 0 for rows in cursor.tables(): if rows.