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

43 votes178 views5 answers
Pandas iterrows
Python
1 vote230 views1 answer
Get current site django
Python
2 votes228 views2 answers
Slow print python
Python
27 votes200 views2 answers
Python null
Python
0 vote167 views1 answer
Set permissions role discord.py
Python
0 vote304 views1 answer
Python codes for counting the occurrence of a letters in dictionary excluding digits
Python
-1 vote178 views1 answer
How to make a ip tracker in python
Python
0 vote203 views1 answer
Verbose python
Python
2 votes176 views1 answer
Clone website
Python
0 vote175 views1 answer
PHP echo multiple lines example Using concatenation assignment operator
Python