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 quot;My Data
Sourcesquot; if I click quot;refresh Dataquot;. Will it just go to there? Or will it
update from the database itself?
3. If it just updates from quot;May Data Sourcesquot; and that does not update
automatically from the database, how can I update those tables from the
database?
- Nov 18 Sat 2006 20:10
Access tables in Excel
close
全站熱搜
留言列表
發表留言