I was wondering if it is possible. I need to autopopulate excel file with information recorded in access table/query. Preferably using VBA.
The table tbl_Electricity has same Property ID's as in excel file. Based on that property ID I need to update usage in excel file.
I have attached sample Excel File and Access file.
Any help would be apreciated