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 vote184 views1 answer
Grepper how to use fraction
Python
0 vote201 views1 answer
Head first python by paul barry pdf
Python
0 vote190 views1 answer
Python parcourir ligne
Python
3 votes187 views2 answers
Change column value based on another column pandas
Python
5 votes187 views3 answers
Python pause function
Python
-1 vote191 views2 answers
How to read tsv file python
Python
0 vote192 views1 answer
Django queryset group by sum
Python
7 votes188 views2 answers
Python list 1 to n
Python
0 vote203 views1 answer
How to write x in terms of y sympy
Python
33 votes189 views10 answers
Elon musk
Python