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

1 vote231 views1 answer
Command prompt pause in python
Python
0 vote211 views1 answer
Pytorch use multiple gpu
Python
0 vote262 views1 answer
Extends template django file system
Python Django
8 votes216 views3 answers
Python gzip file
Python
0 vote233 views2 answers
How to draw a bar graph in python
Python
1 vote205 views1 answer
Numpy random float array between 0 and 1
Python
0 vote229 views1 answer
Django from
Python Django
1 vote205 views1 answer
Keras auc without tf.metrics.auc
Python
12 votes222 views4 answers
Pandas replace values based on condition
Python
0 vote216 views1 answer
Lock in python
Python