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 vote389 views1 answer
Django Signup urls.py
Python
0 vote364 views1 answer
Time track python
Python
0 vote364 views1 answer
Rounding values in pandas dataframe
Python
0 vote361 views1 answer
Create_user() missing 1 required positional argument: 'username'
Python
4 votes337 views5 answers
Random password generator
Python
6 votes370 views2 answers
Decimal in python
Python
0 vote345 views1 answer
Start ipython with any version
Python
0 vote399 views1 answer
Myshop flower notimplementederror
Python
1 vote349 views1 answer
Create spark dataframe in python
Python
8 votes360 views2 answers
Python f-string padding
Python