import pyodbc, csv
conn = pyodbc.connect(r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=C:\db.mdb;')
c = conn.cursor()
sql = ('SELECT * FROM tb1')
c.execute(sql)
res = c.fetchall()
with open("new_file1.csv","w") as file:
       for row in res:
           csv.writer(file).writerow(row)
c.close()
conn.close()

 # OPEN CSV AND ITERATE THROUGH RESULTS
with open('CSVDatabaseWithHeaders.csv', 'w', newline='') as f:
    writer = csv.writer(f)    
    # ADD LINE BEFORE LOOP
    writer.writerow([i[0] for i in cur.description])  
    for row in cur.fetchall() :
        writer.writerow(row)