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 vote296 views1 answer
Multiprocessing a for loop python
Python
0 vote314 views1 answer
Tkinter how to update optionmenu contents
Python
0 vote302 views1 answer
Optimal alpha jupyter
Python
7 votes296 views4 answers
Tensorflow gpu test
Python
4 votes295 views2 answers
Intersection in list
Python
0 vote294 views1 answer
Isenable selenium python
Python
7 votes322 views2 answers
How to generate requirements.txt django
Python Django
0 vote302 views1 answer
Selenium open inspect
Python
0 vote271 views1 answer
Convert python code to c online free
Python
0 vote312 views1 answer
Pandas python3 only
Python