Re: 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" <karthik@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:08BB32D4-CED7-42FA-8EC2-0F5CD4062472@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • RE: Excel Services External Data error
    ... Excel Calculation Services. ... Note that I am getting the data from SSAS 2005 ... and still getting this same solid error on any Excel Service External Data ... Of course the excel 2007 spreadsheet works fine outside of MOSS 2007. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ODBC Conenction Programmatically
    ... Data => Import External Data ... Depending on version of Excel. ... "Todd Huttenstine" wrote in message ... >>Tom Ogilvy ...
    (microsoft.public.excel.programming)
  • Re: Array formulas wont recognize external data from Microsoft Qu
    ... If this fails, try formatting as general first and repeat either route above. ... Microsoft MVP - Excel ... "Nick Hodge" wrote: ... >>> external data as their data source for calculations. ...
    (microsoft.public.excel.misc)
  • Re: Use a database function without importing the data
    ... External data and Import external data. ... I now have the data from the CSV in the Excel cells. ... You don't have to load any data into the sheet. ... I want the bdsum to read the csv file without loading it into a sheet. ...
    (microsoft.public.excel)
  • Resolove a couple bugs in 2000?
    ... Two problems can occur using the Get External Data function. ... Excel prompts a message box requiring acknowledgment when ever the external ... hitting Esc does not work, ... my origional file has a cell ...
    (microsoft.public.excel)