import pyodbc
import pandas as pd

# connecting to access database, DBQ is the location of the access db
conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=M:\Reserving\Data Analyst\Mostafa\Python Scripts\Reserving_DB.accdb')

# running a query 
query = 'SELECT * FROM tbl_Ladder_Data'

#reading a sql query 
reserving_db = pd.read_sql(query, conn)

#closing the connection 
conn.close()

reserving_db.head()