Hi,

Actually an Access table can be linked to an Excel range (best if you name
the range) and then when Excel's data changes the Access table updates.

Probably the best way to do this is to choose File, Get External Data, Link
Data, change the Files of type to Excel and locate your Excel file...

Remember to Name the range in the Excel file first.
--
Cheers,
Shane Devenshire


"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