Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have created a workbook where three sheets are from an access database
(Data/Import external data) (in excel 202 SP3), and a summary/lookup/filter page. I built this workbook on my notebook, working from a copy of the original database. Questions: 1. How can I transfer this to my accountant's computer and redirect the the database to the real one on the office network? 2. I see that Excel grabs the three tables and puts them in "My Data Sources" if I click "refresh Data". Will it just go to there? Or will it update from the database itself? 3. If it just updates from "May Data Sources" and that does not update automatically from the database, how can I update those tables from the database? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Financial modelling from Excel to Access | Excel Discussion (Misc queries) | |||
Excel Access and Oracle | Excel Discussion (Misc queries) | |||
Using Access in Excel VB Code | Excel Discussion (Misc queries) | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
Refreshing Access data in Excel | Excel Discussion (Misc queries) |