Access to Excel

[Greg]

I was using Excel spreadsheet then decided to design first Access database.
Due to my inexperience with Access I'll keep my excel file as a backup.
So here is couple general questions I have before I will go with this project.

Is there is a function in Access (one click button) that will update
automatically to Excel after I added new entry to Access other then
export/import option?

I have different tabs in my Excel file (tab with list of servers, vm,
websites.) If I want to update from Access to Excel is it possible to place
new device name directly under that tab in Excel?
For example: I am adding new server abcd and qwert website to my table in
Access. I want to update Excel and place abcd server directly under server
tab and qwert website under website tab in my Excel file.
Thanks

 

[BlairH]

In Access 97 you could update cells in an Excel spreadsheet the was imported
as a linked table in Access. That functionality was removed in the later
versions of Access

Blair

 

[Laurann]

Do you like Obama?