pulling a field from access into excel when you open the spreadsheet
i'm looking to try and pull the data from an access database into an excel spreadsheet. I can do this one of two ways preferrably. I have an access database of information about people, contact details etc, but i then want to do a simple register to go along with it. now, i think that there are two ways of doing this that should be quite simple, i just don't know how to do them!
first, i thought that i could make it so that when i open the excel spreadsheet, it looks at the database and fills the first column with the names of all the people, much like a lookup does to pull data from 1 sheet to another. the only reason i can think this wouldn't work, is that the database has a password for obvious security reasons.
secondly, i thought that i could do it the opposite way round, and when i open the access database, it automatically opens (and updates?) the spreadsheet. the only problem with this is, i need to be able to add new people to the database, and then they immediately appear inside the excel spreadsheet.
any ideas how to do this? or is there a better way of doing it?