Access to Excel

  • Thread starter Thread starter Greg
  • Start date Start date
G

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
 
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
 
Back
Top