Import Web Data

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
 
S

Steve

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Import External Data by Date Automatically 0
Urgentest: How to Find on the Web a proper-URL_Web-Site_Address to 1
Best Way to Import Data From a Web Browser 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
RTF data from Excel 2007 to Access 2007 1
Import data from web 1
Import External Data 2
Import from web site into access 1

Top