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

4 votes244 views1 answer
Python read dictionary from file
Python
0 vote246 views1 answer
Korozif
Python
0 vote264 views1 answer
Dictionary default value python if key not found
Python
48 votes275 views6 answers
Assembly
Python
0 vote316 views1 answer
Django.core.exceptions.ImproperlyConfigured: Field name is not valid for model
Python Django
1 vote284 views2 answers
Program to print duplicates from a list of integers in python
Python
0 vote270 views1 answer
Return an RDD with the values of each tuple
Python
2 votes250 views2 answers
How to make a latency command in discord py
Python
3 votes271 views6 answers
Counter in python
Python
7 votes281 views2 answers
Python string to array
Python