Update External Data source from Excel sheet

[Guest]

Hi!

I am intrested to create and Excel file or an Access database and save it on
a network drive. This DB will be accessed by Excel files deployed on more
than one machine on the network. Every client would by able to view the data
of the DB through his Excel client and would be able to update the DB if he
wants.

I can use Exteranl Data Range to view data on Excel, but don't know the
proper technique to update. Anybody can comment?

Thanks,
Lara

 

[Guest]

Hi Lara,

You could try right clicking on any of the cells in the excel database drawn
from the access database and selecting 'refresh data'.

Hope this helps.

 

[Guest]

By refreshing data is retrieved from the DB. It override what the client has
changed and shows the original data of DB. What I need is to update the DB
from the client.

Thanks anyway,
Lara