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

10 votes136 views3 answers
Pandas show all dataframe method
Python
0 vote209 views1 answer
In dataframe particular column to string
Python
0 vote155 views1 answer
How to import axes3D
Python
0 vote183 views1 answer
R - scale data from 0 to 1
Python
0 vote151 views1 answer
Cartpole dqn reward max is 200
Python
0 vote167 views1 answer
KivyMD video recording
Python
1 vote147 views1 answer
Tensorflow keras lambda function
Python
0 vote146 views1 answer
Python to postgresql
Python
3 votes138 views4 answers
Seaborn pairplot
Python
0 vote154 views1 answer
Django.core.exceptions.ImproperlyConfigured: Application labels aren't unique, duplicates: auth
Python