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 vote229 views1 answer
Distinct rows in this DataFrame
Python
0 vote154 views1 answer
Time addition in python
Python
2 votes162 views1 answer
Python elementtree build xml
Python
3 votes169 views1 answer
Python run a system command
Python
6 votes210 views3 answers
Flask client ip
Python Flask
0 vote160 views1 answer
How to serach for multiple attributes in xpath selenium python
Python
1 vote149 views3 answers
For j in range python
Python
0 vote165 views1 answer
How to subtract a day from a date?
Python
0 vote198 views1 answer
Python bug
Python
1 vote159 views1 answer
Slicing lexicographically pandas
Python