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 vote283 views1 answer
Flask blueprints
Python
0 vote266 views1 answer
Python numpy array subtract
Python
0 vote261 views1 answer
<ipython-input-31-da456dc89cda> in <module>
Python
0 vote324 views1 answer
Django edit model without loading from db
Python Django
0 vote319 views1 answer
How to run django in jupyter
Python Django
0 vote319 views1 answer
Push to pypi
Python
1 vote270 views1 answer
Elif in django template
Python
0 vote254 views2 answers
Rolling window pandas
Python
23 votes260 views4 answers
Python delete white spaces
Python
0 vote220 views1 answer
Django time cualtulate
Python