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 vote183 views1 answer
InvalidVersionSpec: Invalid version ' 0 . 7 . 1 2 ': invalid character(s)
Python
1 vote224 views1 answer
Python random liste
Python
9 votes172 views2 answers
Remove duplicate row in df
Python
2 votes175 views1 answer
How to change windows icon tkinter
Python
-2 votes215 views1 answer
Django modelform datetime
Python Django
0 vote209 views1 answer
Default ordering django
Python Django
39 votes158 views6 answers
Python check if int
Python
0 vote247 views1 answer
How to compare values in dictionary with same key python
Python
14 votes168 views4 answers
Plt subplots figsize
Python
0 vote171 views1 answer
Vreverse all elemetns of a list in place python
Python