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 vote215 views1 answer
Mirror 2d numpy array
Python
0 vote220 views1 answer
How to use python-socker.io with fast api
Python
5 votes232 views2 answers
Pyaudio not installing ubuntu
Python
1 vote219 views1 answer
Python append n numbers to list
Python
0 vote210 views1 answer
Create graph, x y axis | graph plotting
Python
-1 vote200 views1 answer
Use linear regression to predict python
Python
32 votes202 views3 answers
Read csv python pandas plot
Python
0 vote267 views1 answer
Change set item python
Python
0 vote191 views1 answer
How to multiply integer value with float values in python
Python
1 vote150 views1 answer
Reverse slice python
Python