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 vote170 views1 answer
How many handshakes for all the people in your class? python code
Python
1 vote180 views1 answer
Round godot
Python
0 vote146 views1 answer
Create series with number intervals
Python
0 vote132 views1 answer
How to plot multiple images in python
Python
0 vote201 views1 answer
Python datetime move forward one day
Python
45 votes178 views1 answer
How to turn python vs code into a executable
Python
1 vote174 views1 answer
Remove duplicate rows in csv file python
Python
0 vote188 views1 answer
Iterating over the two ranges simultaneously and saving it in database
Python
19 votes171 views1 answer
Find root directory of jupyter notebook
Python
0 vote167 views1 answer
Pip neat
Python