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 vote189 views1 answer
Os get directory from string
Python
6 votes146 views2 answers
Append to csv python
Python
107 votes153 views6 answers
Python do while loop
Python
0 vote150 views1 answer
Use module Crypto.Cipher.PKCS1_OAEP instead
Python
13 votes147 views3 answers
How to take user input in a list in python
Python
1 vote184 views1 answer
Django model query add annotation field to show duplicate count
Python
0 vote162 views1 answer
Python binary remove 0b
Python
28 votes178 views2 answers
Making your own range function in python
Python
0 vote142 views1 answer
Calculating difference of elemetns in array python
Python
0 vote192 views1 answer
Parquet pyspark
Python