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 vote148 views1 answer
Python get host.docker.internal ip site:stackoverflow.com
Python
0 vote236 views1 answer
Pandas df where row has na
Python
0 vote145 views1 answer
Time current time python time.time
Python
0 vote147 views1 answer
Print("python is good")
Python
1 vote143 views1 answer
Colab save figure
Python
0 vote149 views2 answers
Generate-thumbnails-in-django-with-pil
Python
0 vote148 views2 answers
Search string array python
Python
4 votes145 views1 answer
How to make a list string in python
Python
0 vote182 views1 answer
Take substring of every element in dataframe
Python
0 vote181 views1 answer
Flask decorator causes views to be named the same thing
Python Flask