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

42 votes271 views6 answers
Pandas dataframe
Python
2 votes260 views4 answers
Python dict get random key
Python
12 votes258 views6 answers
Python hello world program
Python
0 vote270 views1 answer
Split the string using the separator
Python
0 vote251 views1 answer
Get ip address in django
Python
2 votes247 views1 answer
Running selenium on google colab
Python
0 vote256 views1 answer
How to change dtype object to int
Python
0 vote244 views1 answer
Limit of list in python
Python
0 vote245 views6 answers
Selenium interview questions 2019
Python
0 vote262 views1 answer
How to find mean of one column based on another column in python
Python