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 vote295 views1 answer
Pandas dataframe read string as date
Python
-2 votes302 views1 answer
How to make discord.py rewrite bot dm someone
Python
0 vote323 views1 answer
Delete file in django terminal
Python Django
4 votes323 views2 answers
Django reset database
Python Django
0 vote296 views1 answer
How to implement dfa in python
Python
2 votes314 views1 answer
How to add headers in csv file using python
Python
7 votes278 views1 answer
Program to find even numbers in python
Python
0 vote314 views1 answer
Divide a column value in pandas dataframe
Python
1 vote297 views1 answer
Cv2 reverse contrast
Python
2 votes317 views2 answers
Django and operator
Python