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 vote274 views1 answer
Python - Comment préparer la capitalisation
Python
1 vote332 views1 answer
On member leave event in discord.py
Python
2 votes264 views1 answer
Numpy how to slice individual columns
Python
0 vote328 views1 answer
A int and float python
Python
3 votes270 views1 answer
How to exit command prompt
Python
0 vote274 views1 answer
405 status code django
Python
-1 vote255 views1 answer
Python how to find the highest even in a list
Python
11 votes287 views6 answers
Write list to csv python
Python
0 vote437 views1 answer
Flask request file upload to dropbox
Python Flask
0 vote305 views1 answer
Gets an existing SparkSession or, if there is no existing one, creates a new
Python