On Feb 24, 9:56 am, CmK wrote:
Hi

I have a spread sheet that read off access but i was wondering if i change
the spread sheet data in excel can access read this to update the data in
access

Also can excel update in realtime or do i have to fresh refresh button all
the time

thanks

To refresh, open worksheet that has your imported data from ACCESS,
click on External Data Range Properties, Click on Refresh every and
tell how often you want it to automatically refresh.