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

4 votes227 views2 answers
Python code to open windows command prompt
Python
1 vote195 views1 answer
Fibonacci series using recursion
Python
1 vote224 views1 answer
Assert len(lex) < self.bucket_specs[-1][1]
Python
37 votes197 views1 answer
Time format conversion in python
Python
2 votes234 views2 answers
Add time to datetime python
Python
0 vote208 views1 answer
Pie chart python pandas
Python
19 votes214 views1 answer
Python left string
Python
3 votes187 views1 answer
Python not equal to
Python
3 votes213 views2 answers
How to print anything in python
Python
5 votes205 views3 answers
Extract zip file python
Python