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

8 votes148 views2 answers
Pandas return first row
Python
0 vote141 views1 answer
Row to column python numpy
Python
0 vote142 views1 answer
Sentence similarity spacy
Python
22 votes226 views6 answers
Python factorial
Python
8 votes159 views6 answers
How to make lists in python
Python
1 vote160 views1 answer
Each line in a text file into a list in Python
Python
1 vote147 views2 answers
Python timedelta to seconds
Python
1 vote289 views1 answer
How to make a countdown in pygame
Python
1 vote160 views1 answer
Python regex for a url
Python
2 votes215 views2 answers
Python program to find first n prime numbers
Python