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 vote288 views2 answers
Youtube net worth
Python
9 votes331 views1 answer
Discord.py set activity
Python
21 votes349 views3 answers
Python if not null or empty
Python
0 vote315 views1 answer
Python use orange
Python
0 vote325 views1 answer
If number Of Players == >=4 python
Python
0 vote351 views1 answer
Get all subsets of a list python
Python
0 vote303 views1 answer
Nornir config file
Python
4 votes332 views2 answers
Remove columns that start with pandas
Python
9 votes300 views2 answers
Default flask app
Python
2 votes310 views2 answers
Pandas set options
Python