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 vote197 views1 answer
Roll a dice
Python
0 vote245 views1 answer
Python linked list insert
Python
0 vote195 views1 answer
Import data from website pandas python medium
Python
0 vote206 views1 answer
Python move cursor to previous line
Python
0 vote190 views1 answer
Python check equality of floats
Python
0 vote209 views1 answer
Print all variables jupyter notebook
Python
0 vote197 views1 answer
Django queryset last 10
Python
0 vote218 views1 answer
Fast guess for divisible numbers between two numbers
Python
26 votes213 views4 answers
Python ceiling
Python
8 votes253 views1 answer
Discord.py making a bot join
Python