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

1 vote267 views1 answer
Django model query join
Python Django
0 vote265 views1 answer
Set title name in steamlit 0.790
Python
0 vote234 views1 answer
Import all images from folder python
Python
0 vote231 views1 answer
Python save list to text
Python
59 votes232 views6 answers
Class in python
Python
71 votes244 views6 answers
Alphabet list python
Python
1 vote239 views1 answer
Why when I merge my label cluster with my dataframe i get more row
Python
1 vote271 views1 answer
Python module install a whl
Python
15 votes236 views3 answers
Group by 2 columns pandas
Python
2 votes195 views1 answer
Python check if email is valid
Python