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 vote99 views1 answer
Generate 50 characters long for django
Python
1 vote108 views1 answer
Conda requests
Python
0 vote99 views1 answer
Python global site packages
Python
18 votes119 views3 answers
How to use histogram in python
Python
0 vote191 views1 answer
Modify a list with for loop and range function in python
Python
1 vote106 views2 answers
How to make a game in python
Python
0 vote107 views1 answer
Django Signup urls.py
Python
1 vote107 views1 answer
Rename one dataframe column python
Python
7 votes108 views2 answers
Axis font size matplotlib
Python
1 vote110 views1 answer
ImportError: Couldn
Python