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

54 votes275 views2 answers
How to run django requirement.txt
Python Django
0 vote153 views1 answer
Earthpy
Python
0 vote169 views1 answer
Django command to fetch all columns of a table
Python Django
15 votes139 views3 answers
Ffmpeg python
Python
1 vote133 views1 answer
Python read entire file as string
Python
0 vote132 views1 answer
Cast image to float32
Python
12 votes143 views1 answer
Python check if has attribute
Python
0 vote143 views2 answers
Feature selection python
Python
1 vote143 views1 answer
How to execute python program in ubuntu
Python
5 votes186 views2 answers
Conda install spacy
Python