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

2 votes253 views1 answer
Ski learn decision tree
Python
4 votes255 views5 answers
How to take multiple integer input in python
Python
0 vote301 views2 answers
Flask lazy response style with `make_response`
Python Flask
5 votes300 views2 answers
How to set icon in tkinter
Python
0 vote270 views1 answer
Clear text box tkinter python
Python
0 vote282 views1 answer
AttributeError: 'NoneType' object has no attribute 'dropna'
Python
0 vote284 views1 answer
Extract images from html page based on src attribute using beatutiful soup
Python
0 vote208 views2 answers
Rename second column pandas
Python
0 vote255 views1 answer
Add metadata png PIL
Python
0 vote224 views1 answer
How to save string json to json object python
Python