LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Question about linking Access to Excel.

Hello,
I have a access database that stores all the tables and the queries
that I want to dump on an excel sheet. On the excel sheet, I want to
create a button call Refresh Data & Calculate Report, so whenever the
user opens the excel sheet and clicks on the Refrest button, the new
data that has been stored in Access gets feed into the Excel. How do
I set up that button in Excel and how do I create that link between
Access and Excel?

thanks!
 
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
Linking access and excel Linda Excel Discussion (Misc queries) 0 November 5th 07 05:07 PM
Linking Excel to Access AB Excel Discussion (Misc queries) 0 December 5th 06 02:06 PM
linking access to excel Season Excel Discussion (Misc queries) 0 December 5th 05 10:48 PM
Linking Excel to Access. Richard Excel Discussion (Misc queries) 3 February 15th 05 09:55 PM
Excel Linking to Access MSSQLServerDeveloper Excel Programming 4 February 5th 05 06:01 AM


All times are GMT +1. The time now is 04:51 PM.

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

About Us

"It's about Microsoft Excel"