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 votes208 views2 answers
Or operator django
Python
34 votes205 views3 answers
Python string replace variable
Python
1 vote202 views1 answer
Python truncate to integer
Python
0 vote224 views1 answer
Write a program to print fibonacci series upto n terms in python
Python
9 votes215 views3 answers
A value is trying to be set on a copy of a slice from a DataFrame. Try using .loc[row_indexer,col_indexer] = value instead
Python
1 vote233 views1 answer
Maiusculo em python
Python
4 votes213 views1 answer
How to make a list string in python
Python
0 vote222 views1 answer
Python convert exponential to int
Python
11 votes217 views2 answers
Python code to wait
Python
0 vote222 views1 answer
Min_max_scaler.fit_transform
Python