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 vote119 views1 answer
How to use with statementin python 2.4
Python
0 vote119 views1 answer
Radians in python turtle
Python
56 votes112 views2 answers
Convert date string to date time string python
Python
0 vote150 views1 answer
Python take the month of date in new column
Python
0 vote116 views2 answers
Count specific instances in a columb in pandas
Python
0 vote116 views1 answer
How to get parent model object based on child model filter in django
Python
0 vote124 views1 answer
Python add datetime to filename
Python
0 vote215 views1 answer
Cuda memory in pytorch
Python
1 vote152 views1 answer
Counter in django template
Python Django
0 vote128 views3 answers
Extracts attribute python xml
Python