Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Access and Oracle | Excel Discussion (Misc queries) | |||
Using Access in Excel VB Code | Excel Discussion (Misc queries) | |||
automation from access into excel | Excel Discussion (Misc queries) | |||
Using Access database to "populate" Excel Sheets | Excel Discussion (Misc queries) | |||
Changing the format of an Excel output file made by Microsoft Access | Excel Discussion (Misc queries) |