connect_to_Game_Plan_run_query.py

Enter file contents here  # -*- coding: utf-8 -*-
import pypyodbc,csv
pypyodbc.lowercase = False
conn = pypyodbc.connect(
    r"Driver={Microsoft Access Driver (*.mdb, *.accdb)};" +
    r"Dbq=H:\GamePlanMaster\GamePlanMaster 2.accdb;")
cur = conn.cursor()
for table_name in cur.tables(tableType='TABLE'):
    print(table_name)
    cur.execute("SELECT * FROM WMS_worksheet_OPS_Plan_linked")
    rows = cur.fetchall()
    for row in rows:
        print (row)