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 vote213 views1 answer
Django dump previous migrations
Python Django
0 vote158 views1 answer
How to skip the first line of a csv file
Python
0 vote188 views1 answer
Pyplot x vs y
Python
2 votes179 views1 answer
Django create model from dictionary
Python
5 votes197 views2 answers
Df.shape 0
Python
2 votes157 views2 answers
Install curses python
Python
-1 vote165 views1 answer
Percentage plot of categorical variable in python woth hue
Python
1 vote196 views1 answer
How to make jupyterlab see other directory
Python
0 vote160 views1 answer
How to add column to heroku postgres in my django app
Python
0 vote169 views1 answer
Online python formatter and compiler
Python