Ms access python dataframe

import pyodbc
import pandas as pd
...
cnxn = pyodbc.connect('DRIVER={{Microsoft Access Driver (*.mdb, *.accdb)}};DBQ=' + \
                      '{};Uid={};Pwd={};'.format(db_file, user, password)

query = "SELECT * FROM mytable WHERE INST = '796116'"
dataf = pd.read_sql(query, cnxn)
cnxn.close()

Source: stackoverflow.com

Similar codes

0 vote368 views1 answer
How to work with django ornm __in
Python Django
6 votes316 views6 answers
Ternary operator in python
Python
4 votes335 views1 answer
Get prime number python
Python
0 vote374 views1 answer
Django-mathfilters
Python Django
0 vote382 views1 answer
Django filter values with e and operator
Python Django
5 votes327 views2 answers
Groupby and list
Python
1 vote325 views1 answer
Getting multiple selected value django
Python
0 vote298 views1 answer
Check status code urllib open
Python
0 vote360 views1 answer
Elementwise comparison list python
Python
0 vote304 views1 answer
Maior valor lista python
Python