Update SharePoint List from Excel to Access DB

[helpshiela]

I have here an Excel Workbook that has forms and that has 1 sheet that is connected to Access Database (1 table only). I linked it by finding the Excel sheet path.


I can see that whatever data I add in Excel sheet, it reflects to Access database and it's good. I am not using Access Database queries to run my Excel form. I only use Excel VBA codes for my form.


Now, I want to send my colleagues via email a copy of the Excel Workbook which has a sheet that is connected to Access Database and simply let them use it to also save data in the same Access Database table. Here are my questions since I have not done this before.




1. Should I send the Excel Workbook together with Access Database?


2. I tried to upload the Access Database table to SharePoint. It was a successful upload. I tried to add data to the Excel Sheet and see if SharePoint also updates (since I already uploaded the Access Database). But as I checked/refreshed SP. It was not updated.

My one and only purpose: add a row of data to Excel sheet that should reflect in Access DB and SharePoint List

Please advise.

[ranman256]

can you just LINK the excel sheet into access as an external table?
and never have to download it.