Thread
:
Store Excel Results in Access
View Single Post
#
4
Posted to microsoft.public.excel.misc
tony h
Posts: n/a
Store Excel Results in Access
You can just use a linked table. Tables/new/linked tabel - then choose
type-of-file as .xls. You can then link either to a worksheet or to a
namedRange.
This will import from the currently saved version of excel.
regards
Ardus Petus Wrote:
I think Ernie wants the other way rounde: Excel - Access.
He'll have to use ADO
HTH
--
AP
"Tom Ogilvy"
a écrit dans le message de
...
from access you can link to excel
Use something like File=Get External Data =Import
--
Regards,
Tom Ogilvy
"ernie"
wrote in message
...
is there some way to have excel store its calculated results in
access
for
making reports, etc... isnt there some way to create a button so
that
after
excel calculates u can click on the button to have it store selected
cells
in
an access database??? or something like that..?
thanks in advance
--
help a friend help you
--
tony h
Reply With Quote