User16764241763
Databricks Employee
Databricks Employee

@Dhara Mandal​ Can you please try below?

# cmd 1
%pip instal pandas_access
 
# cmd 2
import pandas_access as mdb
 
db_filename = '/dbfs/FileStore/Campaign_Template.mdb'
 
# Listing the tables.
for tbl in mdb.list_tables(db_filename):
    print(tbl)
 
# Read a small table.
df = mdb.read_table(db_filename, "Campaign_Table")
df.head()

image 

This article has some examples

https://stackoverflow.com/questions/25596737/working-with-an-access-database-in-python-on-non-window...