Check Policy Number in Access table and populate related data in Excelsheet using vba

Hi Guys

Please see attached the Workbook. I need to check the policy Numbers in Column A to be present in Access Table. If yes then write the corresponding ScanDate and BatchNo in columns I and J.

I need to write VBA code to perform it.

Any help would be much appreciated.

Thanks