Directly connected Excel worksheet for an Access Form
I have created my own MS Access based (Ver2002) " Contact Management" data
base to have a data base for my Family, friends , vendors and other's Family
details, contact addresses and Phone nos etc. Now, I would like to have only
a few selected fields like ' Family Name ', ' Phone Off ', ' Phone Res '. '
Mob Phone ' records to be displayed in an Excel worksheet with a Link so that
whatever updates I make thro the Access Form is reflected in this Excel sheet
live. Kindly suggest the procedure.
|