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

8 votes341 views1 answer
Python how to check if a dictionary key exists
Python
4 votes369 views4 answers
Filter django or
Python Django
16 votes337 views2 answers
Python reload class
Python
2 votes337 views1 answer
Python half of string
Python
36 votes340 views1 answer
Sleep in py
Python
0 vote356 views1 answer
Flask debugtoolbar
Python Flask
17 votes360 views5 answers
Append element to list py
Python
1 vote305 views1 answer
Plotly font size
Python
-3 votes394 views1 answer
ValueError: With n_samples=0, test_size=0.2 and train_size=None, the resulting train set will be empty. Adjust any of the aforementioned parameters.
Python
3 votes316 views1 answer
Visualize correlation matrix python
Python