Python odbc access database

import pyodbc

conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path where you stored the Access file\file name.accdb;')
cursor = conn.cursor()
cursor.execute('select * from table name')
   
for row in cursor.fetchall():
    print (row)

Source: datatofish.com

Similar codes

0 vote94 views1 answer
Flask decorator causes views to be named the same thing
Python
0 vote150 views1 answer
Django populate database in view
Python Django
0 vote99 views1 answer
Get duplicate and remove but keep last in python df
Python
1 vote101 views1 answer
Python how much memory does a variable need
Python
15 votes109 views2 answers
'jupyter' is not recognized as an internal or external command, operable program or batch file.
Python
13 votes91 views5 answers
How to create role discord.py
Python
3 votes142 views1 answer
Python add legend title
Python
0 vote93 views1 answer
How to get values in each cluster
Python
0 vote88 views1 answer
Taggablemanager serializer django
Python
1 vote237 views1 answer
ModuleNotFoundError: No module named 'lmdb'
Python