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

-1 vote164 views3 answers
Try using .loc[row_indexer,col_indexer] = value instead
Python
4 votes254 views1 answer
Get prime number python
Python
0 vote136 views1 answer
"not equal to" python symbol
Python
0 vote163 views1 answer
Read api from django
Python Django
0 vote147 views1 answer
Python Tkinter timer animation
Python
9 votes123 views1 answer
Cv2.cvtcolor grayscale
Python
0 vote149 views3 answers
Dataframe row print
Python
1 vote155 views1 answer
How to input 2-d array in python
Python
1 vote135 views1 answer
Verificar se arquivo existe python
Python
2 votes190 views3 answers
Marks input using list in python
Python