We have an MS Access database file and an excel sheet in the same sharepoint site.
We have read the rows from this excel sheet and append them into a table of the mentioned Access database.
We are wondering if we can write VBA macros in the MS Access database to access the excel file in sharepoint site, read the rows from it
and append them into Access database.
Wondering if sharepoint web-services are a solution for this.
Can somebody provide a lead on this please?