stickyb,
Problem is that it doesn't automatically update, you have to reopen Access to allow it to recognise the changes. Also, it won't allow me to insert a new entry between existing rows in the linked spreadsheet. Or I havn't figured out how to yet, which is more than likely! Basically, I want to be able to access and modify the Spreadsheet as if it was part of the database, whilst keeping it seperate.
Any more suggestions?
* Just had a thought - Would it be possible to write a macro or
VB procedure to re-import data from the Spreadsheet every time a change was made in the database? Or would this take too long or drain system resources?