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

5 votes131 views2 answers
How to reset username and password in django admin
Python Django
0 vote114 views1 answer
Is dictreader scoped in python
Python
9 votes103 views2 answers
Read live video from usb opencv python
Python
0 vote115 views1 answer
Geopandas plot fullscreen
Python
0 vote115 views1 answer
Math domain error python
Python
0 vote110 views1 answer
Faster way to find list of unique elements in a list
Python
5 votes102 views2 answers
Openpyxl read excel
Python
0 vote117 views1 answer
Mutiplication of two number in python
Python
0 vote97 views1 answer
Python identify array
Python
0 vote111 views1 answer
How to write a dataframe to s3 object in python
Python