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

9 votes357 views6 answers
Elif python
Python
13 votes347 views3 answers
How to combine two lists in one python
Python
2 votes324 views2 answers
Count gabarit django
Python
0 vote317 views1 answer
Flip pyplot python
Python
26 votes349 views2 answers
Python time library
Python
1 vote353 views2 answers
Django client ip
Python
0 vote328 views2 answers
Python dict for k v
Python
-1 vote338 views2 answers
How to do date time formatting with strftime in python
Python
0 vote378 views1 answer
Python string: .lower()
Python
5 votes351 views2 answers
Importing python module from different directory
Python