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

2 votes281 views3 answers
How to get a number from a string in python
Python
1 vote279 views1 answer
How to convert adjacency list to adjacency matrix
Python
0 vote239 views1 answer
Is vs == python
Python
0 vote273 views1 answer
How to load user from jwt token request django
Python
0 vote300 views1 answer
Range function in python use cases
Python
1 vote270 views1 answer
Python value error
Python
1 vote272 views1 answer
Animations text terminal python
Python
0 vote323 views1 answer
How to set and run flask app on terminal
Python Flask
0 vote276 views2 answers
Convert numpy array to HSV cv
Python
1 vote265 views2 answers
Python numpy delete element from array
Python