Use Assess to do a Web Query?

[ryguy7272]

Is there a way of doing a web query with Access? I wanted to import data
from the web, into various tables, similar to the way Excel imports data from
the web. Does anyone know how to do this, or does anyone know of a resource
on the web that describes how to do this?


Regards,
Ryan--

 

[Justo Morales]

Is there a way of doing a web query with Access? I wanted to import data
from the web, into various tables, similar to the way Excel imports data from
the web. Does anyone know how to do this, or does anyone know of a resource
on the web that describes how to do this?


Regards,
Ryan--

Hello Ryan,

One way of doing this is to link the table from a web page. This is
done the same way as linking from Excel. The difference is that you
enter a web address instead of a file. Next, you select the table you
want to link. From there on, you can create queries against the linked
table just as you do with any other table.

If you need more info, post a response.

 

[ryguy7272]

Could you please give me a play-by-play for this process? I've done this
many, many, many times in Excel, but never in Access.

Regards,
Ryan---

 

[Nicholas Meyer]

nice name ryguy7272

 

[ryguy7272]

How can I link the table from a web page? How do I enter a web address?

Regards,
Ryan---

 

[Justo Morales]

Before I give you the steps, let me precede this by stating that you may
only link local HTML files. I have done this before and somehow was
confused that you can also do it on live web pages. If you want to
import data from a live web page, you will have to save it onto an HTML
file first. If you need instructions on how to do this, please post the
request. Otherwise, I am going to assume you know how to save a web
page onto an HTML file.

Here are the steps (I am using Access 2003):

* Click on Tables in the Objects list of the database window.
* Click on New on the database window.
* Select link table from the New Table dialog box and click OK.
* In the File Type field, select HTML Documents.
* In the File Name field, browse to wherever you saved the file.
* Click on the Link button
* If you have more than one table, you will have to go through the list
until you find the table you are looking for. Select it and click next.
* Otherwise, if you have one table, you will be presented with the table
already.
* If you have column heading, click on the checkbox.
* Click the next button.
* You may click on each column and rename it and select the data field.
Or, you can leave it as is.
* Click Next when you are done.
* Last, name the table (I usually precede the name with lnk to alert me
that it is a linked table) and click on Finish.

That's it. Hopefully you didn't run into any issues. If you did,
please post the details.

Also, you may go back to the original web page and "re-download" to
update the local HTML file. As long as the name is the same, you should
be fine and the linked table within access will automatically update.

Please post any comments and issues you may encounter.

 

[ryguy7272]

Very clever, very clever indeed. I've used this technique with Excel, but
didn't even think of do it this way with Access. Thanks for the tip!!

Regards,
Ryan---

--
RyGuy

How can I link the table from a web page? How do I enter a web address?

Regards,
Ryan---