Hi @Geetha ,
If you have installed Microsoft Access Database Engine 2016, I guess that you still need to set the Provider argument of the ConnectionString property.
1.If you are an application developer using OLEDB, set the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”
2.If you are an application developer using ODBC to connect to Microsoft Office Access data, set the Connection String to “Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path to mdb/accdb file”
3.If you are an application developer using ODBC to connect to Microsoft Office Excel data, set the Connection String to “Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=path to xls/xlsx/xlsm/xlsb file”
Please refer to install instructions of Microsoft Access Database Engine 2016 Redistributable to get detail information.
Best regards,
Cathy
If the response is helpful, please click "Accept Answer" and upvote it, thank you.