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

2 votes333 views3 answers
Miles to km in python
Python
8 votes330 views4 answers
Python zip folder
Python
3 votes430 views1 answer
ModuleNotFoundError: No module named 'django.core.urlresolvers'
Python Django
1 vote298 views1 answer
Torch concat two 1d tensor
Python
79 votes323 views3 answers
Reverse element in a list in python 3
Python
2 votes303 views1 answer
Matplotlib plot remove margins
Python
24 votes348 views6 answers
Palindrome python
Python
20 votes378 views5 answers
Remove first character from string python
Python
0 vote420 views1 answer
No module named 'django_hitcounter'
Python Django
10 votes340 views2 answers
How to find length of number in python
Python