Deirdre Marie
Access in Excess
- Local time
- Today, 12:07
- Joined
- Sep 17, 2001
- Messages
- 34
Please forgive me if this question is a no-brainer for all of you.
My company still uses the good ol AS400 for storing a lot of information. Currently, we download some of this information into an ACCESS database for our manipulation pleasures.
What I would like to do is then link the ACCESS database into an Excel workbook (because the people needing the info have a great fear of access and are more comfortable with Excel) - BUT- have the workbook automatically reflect any changes that are made in ACCESS.
I know this can be done the other way around (Make a change in Excel and have it reflected in ACCESS), but can it be done from ACCESS to Excel?
Thanks much!
My company still uses the good ol AS400 for storing a lot of information. Currently, we download some of this information into an ACCESS database for our manipulation pleasures.
What I would like to do is then link the ACCESS database into an Excel workbook (because the people needing the info have a great fear of access and are more comfortable with Excel) - BUT- have the workbook automatically reflect any changes that are made in ACCESS.
I know this can be done the other way around (Make a change in Excel and have it reflected in ACCESS), but can it be done from ACCESS to Excel?
Thanks much!