Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 48
Default Link Access data in Excel

I have set of pre defined table in access. i want to access those datas in
excel with refersh option, since my data in access will change periodically.

if possible, anybody can suggest me as ground work. i am novice inthis field.


thanks in advance,
karthik
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Link Access data in Excel

In Excel:
Data=Get External Data

follow the wizard to create a query table in Excel.

--
Regards,
Tom Ogilvy


"karthik" wrote in message
...
I have set of pre defined table in access. i want to access those datas in
excel with refersh option, since my data in access will change
periodically.

if possible, anybody can suggest me as ground work. i am novice inthis
field.


thanks in advance,
karthik



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
External data link to Access - no linked tables? Grant I Excel Discussion (Misc queries) 3 January 30th 09 06:27 AM
link Access DB to excel WS to share certain data, not whole DB, ho Bonnie Sunrise Clarksville Excel Discussion (Misc queries) 1 September 17th 06 03:08 PM
Updating data with an ODBC link to ACCESS Excel Worksheet Functions 1 July 6th 06 02:09 PM
ole link from excel to access JCanyoneer Excel Programming 0 December 20th 05 05:20 PM
Link Data in specific cell in Access to Excel Dustin Excel Programming 0 January 26th 04 05:43 PM


All times are GMT +1. The time now is 06:45 AM.

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"