I use Excel to link to data from a web site (using the 'Import External 
Data>New Web Query), each time I open the Excel file the data is refreshed 
and I see the latest update without having to go and get it manually. I want 
to do the same in Access but haven't seen a way of doing it yet.

Is it possible, if so, How ?

Thanks

Keith

It is possible to open Excel but not visible from Access. You could then 
import the data into Access. Another thing that could be done is link to the 
data in Excel from Access. After you open Excel invisible from Access you 
would only need to refresh the link.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@pcdatasheet.com





"Keith" <me@here.com> wrote in message 
news:ueI8hYWpHHA.2044@TK2MSFTNGP04.phx.gbl...
>I use Excel to link to data from a web site (using the 'Import External
> Data>New Web Query), each time I open the Excel file the data is refreshed
> and I see the latest update without having to go and get it manually. I 
> want
> to do the same in Access but haven't seen a way of doing it yet.
>
> Is it possible, if so, How ?
>
> Thanks
>
> Keith
>
>
>
>