Pull info from access to template in excel?????
Hi JR,
You could use the External Data feature of excel (menu Data External Data
New Database Query...).
Once data is loaded, click on the data. Now, there should be a Query toolbar
and additional commands in the menu Data External Data ... with
additional options/settings.
Eg: you can set the query as a background query, to refresh every x minutes,
when the file opens...
This feature may not be flexible enough though. In this case, please let us
know in detail what you are try to accomplish.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com
"jwr" wrote:
I am new to anything in excel other than the standard worksheets.
I need to create a template in excel that will pull information from my
access database. I have no idea as to how to accomplish this.
Can you give me any direction?
Thank you,
JR
|