Changing Query to get external data

  • Thread starter Thread starter Andyjim
  • Start date Start date
A

Andyjim

Hi-
Could someone explain the mechanics of editing an existing query that gets
investment quotes from the Internet. This site has changed their table and
we need to change our query accordingly.

I thought perhaps just delete the existing query and start again, but I
haven't figured out how to do that.

Thanks for your help.

Andy
 
To remove a query go to Files - Properties - Custom on the worksheet menu.

Add query Data - Import External Data - New Web Query. Then put webpage URL
into address bar.
 
You must log in or register to reply here.

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

External Data Query 3
External Data Refresh Issues 0
Getting query data from Access 1
External data link to Access - no linked tables? 3
Get External Data - not editable using Query Wizard 7
Creating auto Updating Pivot Table linked to external data. 1
Changing query data source 1
Get External Data grayed out 10

Back
Top