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 vote210 views1 answer
Empty argument as a parameter in python function using None
Python
0 vote202 views1 answer
CharAt in Python
Python
1 vote197 views2 answers
Python sort list of integers
Python
1 vote201 views2 answers
Boto3 delete bucket object
Python
0 vote210 views1 answer
How to do a mac vendor lookup in python
Python
0 vote211 views1 answer
Python ValueError: zero-size array to reduction operation maximum which has no identity
Python
5 votes207 views3 answers
Convert list to dataframe
Python
0 vote196 views1 answer
Pandas.describe per group
Python
-1 vote197 views1 answer
Explained if name main python
Python
15 votes205 views2 answers
Post request in python flaks
Python