Store Excel Results in Access

E

ernie

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
 
T

Tom Ogilvy

from access you can link to excel

Use something like File=>Get External Data =>Import
 
A

Ardus Petus

I think Ernie wants the other way rounde: Excel -> Access.

He'll have to use ADO

HTH
 
T

tony h

You can just use a linked table. Tables/new/linked tabel - then choos
type-of-file as .xls. You can then link either to a worksheet or to
namedRange.

This will import from the currently saved version of excel.

regards
 
Top