Store Excel Results in Access
 

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

Store Excel Results in Access
 

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

Store Excel Results in Access
 

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

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

Store Excel Results in Access
 

How does ADO work?
--
help a friend help you


"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