Auto update - ACCESS to EXCEL

  • Thread starter Thread starter Deboluky
  • Start date Start date
D

Deboluky

I have an ACCESS Database on which I have several enteries
for each client. For weekly reviews, I have to present the
enteries in EXCEL format in a particular column order.

Is it possible to have pointers or macros which will
automatically update my EXCEL sheet for each entry and
each ckient as I manually update my ACCESS pages??
 
You may want to export all the data into excel file, that
is not difficult
if you want to appen the data into excel file, then you
need to write codes

May
MCP in Access and SQL Server
 
In the Microsoft Office Environment, you can automatically
copy and paste a link/word from one application to others
using the Copy and Paste Special option.

Example:
Copy the cell from MS Access
Goto to MS Excel - click on EDIT --select PASTE SPECIAL
Than when you make changes from ACESS it will
automatically change it from the EXCEL.
 
Back
Top