Automatically updating Excel spreadsheet and Outlook from Access.

[Ricky1946]

I have a customer who wishes (against my opinion) to update an external Excel spreadsheet with data from an Access database when exiting the database, so that his spreadsheet is always up to date.
I have advised that he can do all that he wants to do within Access but he insists. How can I reference each cell in the Excel spreadsheet to the relevant field in the database? I wish to be able to do this either with the click of a button or automatically when exiting the program.
He also wants to be able to update his Outlook template in the same manner.
Any suggestions?
Regards
Ian Richards "To say 'thankyou' encourages others."

 

[MontyBurns]

i'd probably add a macro to the xls file which ran on opening the file, which gets the data from the Access DB and updates the spreadsheet, rather than pushing data into the spreadsheet from the Access DB.

Saying that, I have found documentation on the Excel object model etc very hard to find. I'm sure you could update the spreadsheet easily if all you wanted was to import the contents of a table/query, with no formatting etc.

Sorry I can't be of more help.
Burns

 

[Ricky1946]

No that sounds a logical point. I will give it a try.
Many thanks
Ian "To say 'thankyou' encourages others."