How to import data from HTML file or page?

  • Hi all,

    So I have this html page: https://ofsistorage.blob.core.windows.net/publishlive/2022format/ConList.html

    On this page there is data that looks like this:

    12

    I want to import this data to my SQL tables using SSIS or SQL queries. What tasks or queries I can use to complete the import process?

    Regards

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Python is used heavily for web scraping, you should give it a try using it to extract the data between the html tags.

    =======================================================================

  • If i am not wrong, it is not only python all web services will turn the page to HTML, HTM etc , you save only those.

    Right click and save the page and try copying from it between the Tags.

    Regards
    Durai Nagarajan

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply