Import Web Data

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

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
(e-mail address removed)
 
Back
Top