Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
widman
 
Posts: n/a
Default Access tables in Excel

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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Financial modelling from Excel to Access Huyeote Excel Discussion (Misc queries) 3 March 9th 11 03:59 PM
Excel Access and Oracle Chris K Excel Discussion (Misc queries) 1 February 17th 06 06:16 PM
Using Access in Excel VB Code Michael Excel Discussion (Misc queries) 1 February 2nd 06 07:31 PM
export access to excel. change access & update excel at same time fastcar Excel Discussion (Misc queries) 0 June 24th 05 09:27 PM
Refreshing Access data in Excel Jimmy G Excel Discussion (Misc queries) 0 December 21st 04 03:53 PM


All times are GMT +1. The time now is 07:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"