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

7 votes125 views1 answer
If else python in single line
Python
0 vote104 views1 answer
How to deploy to heroku djangorest framework app
Python
0 vote167 views1 answer
Remove hh:mm:ss from pandas dataframe column
Python
0 vote129 views1 answer
Spacy create tokenizer
Python
10 votes126 views3 answers
Text recognition python library
Python
0 vote131 views1 answer
Python array of tuples for loop
Python
0 vote127 views1 answer
Register template tag django
Python Django
0 vote94 views1 answer
Foreign key on delete arguments
Python
1 vote99 views1 answer
Minute range python
Python
2 votes119 views1 answer
Python dictionary multiple same keys
Python