Is there a web query functionality similar to Excel in Access

[tushar]

Hi,

I have a requirement wherein -
1. I have four designation, President, Vice Presi, Director, Manager.
2. The relationship is 1 to Many from Left to Right ie One President will have many Vice President, One Vice President will have Many Director.
3. A Manager will be having many project implementation, some of them will be successful, some of them will be failed, post poned, still going.
4. The status of project is maintained at Manager level on a web site.
5. Task is to for a selected President,VP,Dir & manager & Month get the total list of project with status.

Initially, I planned to do it in excel, but then thought, to change to Access(Since I wanted to learn, and also I learnt that in access you can just query on table and assosiate the result to ComboBox, I am not sure if it can be done in Excel).

I have created Combo Box for Presi,VP,Dir & Manager. Now the problem is for this combination, i should query the page and get the data. In excel, this could have been achieved by querying the web page, but i want to know, is there any way we can do this in access or is there any way in excel through which we can retrieve the data from web page.

Please enlighten me on this issue, and also which of the two - excel or access will be good one for this task.

Regards,
Tushar

 

[ajetrumpet]

i actually don't think you can, but what you can do is use HTML in Access language to query a webpage table or form data. however, that is far more advanced than simply using the query wizard in Excel, which basically does the work for you.

i am just spitballing here, but my guess is that you are going to have to use HTML if you want to query the web with access programming...

 

[Rabbie]

One way of tackling this in Access would be to have a linked table to an Excel Spreadsheet. The Excel spreadsheet can be populated as you have outlined in your original post.

 

[tushar]

Thanks Rabbie & ajetrumpet.

Currently, I am using Excel and getting the Data from access using query.
But as ajatrumphet mentioned, I would like to know more on HTML to query web page. Actually, I am Mainframe Programmer, lately dabbling in VB to learn something, and would be great if anyone can give me pointers about using HTML to query web page.

Regards,
Tushar