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

3 votes360 views2 answers
Train_size
Python
27 votes339 views4 answers
Flask tutorial
Python
1 vote338 views1 answer
Numpy vector multiplication
Python
7 votes341 views3 answers
Pandas switch column levels
Python
0 vote335 views1 answer
Tensorboard dev upload in background colab
Python
6 votes353 views2 answers
How to find index of maximum value in dataframe in python
Python
18 votes351 views5 answers
Discord.py get user input
Python
0 vote311 views1 answer
How to pause a thread in python
Python
2 votes335 views1 answer
How to insert a variable into a string without breaking up the string in python
Python
0 vote328 views1 answer
Pythonremove all instances from a list
Python