oh what a tangled web

[wailingrecluse]

Hi all

Does anyone know, is it possible to do a web query in access?

Or do I have to pull the data into a spreadsheet and then link the sheets to access tables?

Thanks in advance,

WR

 

[wiklendt]

not sure what you mean by web query. data access pages were made obsolete in 2007, so if you're using an earlier version of access you may be able to still do this, but i'm not sure how.

i would have thought that the data you are using is in the access database already, and a plain query would do the trick? (sorry, i've never used web-related things in access, so don't really know what i'm talking about BUT i'm happy to throw a suggestion into the mix!)

 

[Banana]

Like wiklendt, I'm not quite sure what you mean by 'web query'.

If you wanted data to be served on a webpage, it's possible, yes, but not natively within Access. You would need to have ASP or PHP or any web scripting to connect to Access & create query and write out the result in the HTML output.

Otherwise, please explain what you expect from a "web query".

 

[georgedwilkinson]

For the edification of those responding: A web query is a technique available in Excel to grab the data from a web page onto an Excel spreadsheet.

It is treated like a database query via the Excel menu system. Once the data is in Excel, it can be manipulated like any other set of data.

Now since I've put my foot in it, I apologize that I don't have a direct answer to the question. The only way I've been able to get data from the web into a database (not Excel) is via the Internet Explorer object available in VBA (in Excel and Access). This required a detailed knowledge about the layout of the target web site because I had to parse the data out of the table.

Did you try poking around in Access' import menus? My guess is that it cannot be done as easily as it is done in Excel.