Reading HTML Tables into Database



Hello
My objective is to programaticly read tables from web pages & use that data
I'm having a hard time linking to a table on an HTML web page.
The DAO documentation show's that it is posible.
But I just don't seem to be able to get it to work.

Can someone please direct me to some good info, better then the scant documentation in MSDN

Thanx in advance!

Ref:
mk:@MSITStore:Your_MSDN_CDMSDNoffice97.chm::/html/workingwithhtmlfiles.htm

Comments

  • :
    :
    : Hello
    : My objective is to programaticly read tables from web pages & use that data
    : I'm having a hard time linking to a table on an HTML web page.
    : The DAO documentation show's that it is posible.
    : But I just don't seem to be able to get it to work.
    :
    : Can someone please direct me to some good info, better then the scant documentation in MSDN
    :
    : Thanx in advance!
    :
    : Ref:
    : mk:@MSITStore:Your_MSDN_CDMSDNoffice97.chm::/html/workingwithhtmlfiles.htm
    :

    You are on the right track. try the Opening HTML Files section of the msdn help. just change the table name into "table"
    note:
    - don't forget the semi-colon on the connection string.
    - for the first table in html file, table name will be = "table", 2nd="table1", 3rd="table2", ...
    - 1st row of the table in html file will be column header

    :-)

  • : :
    : :
    : : Hello
    : : My objective is to programaticly read tables from web pages & use that data
    : : I'm having a hard time linking to a table on an HTML web page.
    : : The DAO documentation show's that it is posible.
    : : But I just don't seem to be able to get it to work.
    : :
    : : Can someone please direct me to some good info, better then the scant documentation in MSDN
    : :
    : : Thanx in advance!
    : :
    : : Ref:
    : : mk:@MSITStore:Your_MSDN_CDMSDNoffice97.chm::/html/workingwithhtmlfiles.htm
    : :
    :
    : You are on the right track. try the Opening HTML Files section of the msdn help. just change the table name into "table"
    : note:
    : - don't forget the semi-colon on the connection string.
    : - for the first table in html file, table name will be = "table", 2nd="table1", 3rd="table2", ...
    : - 1st row of the table in html file will be column header
    :
    : :-)
    :
    :

    Thanx for the Reply
    Looking at the HTML Files section of MSDN Help is what started me on this endevor.
    Did I mention I'm attempting to read a web page via URL?
    The closest I've had to having it work, I get a Read Only Error 3027.



  • : : :
    : : :
    : : : Hello
    : : : My objective is to programaticly read tables from web pages & use that data
    : : : I'm having a hard time linking to a table on an HTML web page.
    : : : The DAO documentation show's that it is posible.
    : : : But I just don't seem to be able to get it to work.
    : : :
    : : : Can someone please direct me to some good info, better then the scant documentation in MSDN
    : : :
    : : : Thanx in advance!
    : : :
    : : : Ref:
    : : : mk:@MSITStore:Your_MSDN_CDMSDNoffice97.chm::/html/workingwithhtmlfiles.htm
    : : :
    : :
    : : You are on the right track. try the Opening HTML Files section of the msdn help. just change the table name into "table"
    : : note:
    : : - don't forget the semi-colon on the connection string.
    : : - for the first table in html file, table name will be = "table", 2nd="table1", 3rd="table2", ...
    : : - 1st row of the table in html file will be column header
    : :
    : : :-)
    : :
    : :
    :
    : Thanx for the Reply
    : Looking at the HTML Files section of MSDN Help is what started me on this endevor.
    : Did I mention I'm attempting to read a web page via URL?
    : The closest I've had to having it work, I get a Read Only Error 3027.
    :
    :
    :
    :

    try this:

    [code]

    Dim db As DAO.Database
    Dim rs As DAO.Recordset

    Set db = OpenDatabase("http://your-url/table.html", False, False, "HTML Import;")
    Set rs = db.OpenRecordset("table2", dbOpenTable)
    Do While Not rs.EOF
    Debug.Print rs(0), rs(1)
    rs.MoveNext
    Loop

    [/code]

    hope this works (it works for me)
    :-)
    Handy
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion