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

17 votes320 views6 answers
Odd or even in python
Python
3 votes309 views1 answer
Djnagi import model form
Python
0 vote325 views1 answer
Van first name van second name van last name
Python
1 vote301 views2 answers
Python character list to string
Python
0 vote300 views1 answer
Csrf token fetch django
Python Django
1 vote258 views1 answer
Check if pandas dataframe contains inf
Python
0 vote303 views1 answer
Py - count if a word is present in a column
Python
-1 vote286 views1 answer
Get key from dict python
Python
0 vote310 views1 answer
Python parser txt to excel
Python
0 vote291 views1 answer
Read image python
Python