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

33 votes186 views4 answers
Python check folder exist
Python
34 votes371 views6 answers
Simple flask app
Python Flask
0 vote189 views1 answer
App = Flask(_name_) NameError: name '_name_' is not defined
Python
3 votes165 views1 answer
Get terminal output in python
Python
1 vote255 views2 answers
Selenium text value is empty in flask returns
Python Flask
21 votes193 views3 answers
How to get the current date hour minute month year in python
Python
0 vote237 views1 answer
Python nth prime function
Python
12 votes194 views1 answer
Copy a dict in python
Python
37 votes207 views6 answers
Turn list into string
Python
2 votes185 views2 answers
Invert y axis python
Python