Append table in Access Database using data from HTML

[rahulmudiraj]

Hi All,



I am new to microsoft access and i am currently using microsoft access 2010

I have a students table in my access database and i have now append this table with data from a HTML

how can i do that? using append query

suggestions would be helpful

Regards,
Rahul M

[June7]

Access has a wizard for importing HTML. Did you try that?

[rahulmudiraj]

Hi ,

Are you talking about HTML document option we have under External Tools?

But this is for a HTML document, but i have to take it from the HTML link ( i should not save it to a document)

Can i have your number please

My number is 785-320-0527

[June7]

I communicate only through forum posts and PM's.


I don't understand what you are doing.

You want to pull data from a web page? Are you downloading a file (csv, spreadsheet) from website?

[rahulmudiraj]

Hi,

I have to pull the data from a html webpage and append it to one of my tables

so i was just curious to know if we can do the same without downloading the html webpage into html document

by just giving the link some where in the access, like pulling data through a webquery and appending it to the existing table

[June7]

Access 2010 introduced WebBrowser control. I have not used it and don't know if it will help you.

[rahulmudiraj]

Thank you, i did add this WebBrowser control, but it was always in a disabled mode, so i was looking for some advice in this group
thankyou again

[orange]

Please post the url you want to link to/get info from.

[June7]

Can't replicate issue you have with the WebBrowser control. I just tested and it works.

Review http://office.microsoft.com/en-us/ac...101631434.aspx
The InsertHyperlink dialog did not automatically open for me. I had to right click > Add Hyperlink

[rahulmudiraj]

http://info.cba.ksu.edu/mchaney/cometevent.htm

this is the link from which i want to take the data and append it to one of my tables in access using a webquery

[June7]

I was able to install WebBrowser control and link to that web page. The data is viewable but not seeing how it can be captured to table programmatically. I was able to select the data and copy/paste to table but pastes all to one column. This is no different than copy/paste from web page in Internet Explorer. I am thinking there is no way to query the web page, regardless of how it is viewed.

I looked at the page source code and it appears to upload data from Excel. If the data were fed into web page elements, might be able to retrieve. This link hints at that possibility http://www.vbforums.com/showthread.p...p-and-Examples. I couldn't identify page elements that hold data.