Linking Excel Spreadsheets to an Access Database

[stickyb]

Originally Posted by Oxeagle

stickyb,

Problem is that it doesn't automatically update, you have to reopen Access to allow it to recognise the changes.

I think the refresh or requery property will solve that problem