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

6 votes187 views3 answers
Float python precision round
Python
5 votes280 views3 answers
Pytorch 1.7
Python
7 votes179 views1 answer
On message discord py
Python
0 vote208 views1 answer
Python code to convert all keys of dict into lowercase
Python
22 votes176 views3 answers
Python except error as e
Python
0 vote209 views1 answer
Onlinecourses.osppro.com
Python
6 votes258 views3 answers
How to split an input in python by comma
Python
1 vote179 views1 answer
Python how to sort by date
Python
3 votes181 views2 answers
Set Intersection
Python
1 vote179 views1 answer
Python edit item in list
Python