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 vote274 views1 answer
Dateien mit modul requests herunterladen python
Python
0 vote303 views1 answer
How to select li element in selenium python
Python
0 vote311 views1 answer
Two labels on one axis python
Python
20 votes300 views6 answers
Add python to path windows 10
Python
13 votes269 views3 answers
How to find and remove certain characters from text string in python
Python
0 vote282 views1 answer
Series has no attirubte reshape python
Python
0 vote271 views1 answer
Python -m pip install -u pip
Python
12 votes295 views10 answers
Timer
Python
1 vote271 views1 answer
Filter with different operator in django
Python
0 vote280 views1 answer
Pytorch forecasting
Python