Access a exccel sheet in sharepoint site using VBA macros

Hi Everyone,

  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?

 

Thank you