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 vote335 views2 answers
Python datetime now minus 3 hours
Python
0 vote354 views1 answer
David dobrik
Python
104 votes335 views5 answers
Split string in python
Python
0 vote341 views2 answers
How to decode hexadecimal in python
Python
2 votes318 views1 answer
Python system of nonlinear equations
Python
0 vote352 views1 answer
Access nested set with array params python
Python
1 vote337 views1 answer
Py file open with
Python
1 vote336 views1 answer
How to search where a character is in an array in python
Python
0 vote307 views1 answer
Django validate_comma_separated_integer_list
Python
1 vote342 views1 answer
Python list add if not present
Python