How to import data from HTML file or page?

• Jobs90312

  Mr or Mrs. 500

  Points: 533

  More actions

  February 28, 2023 at 5:17 am

  #4154861

  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:

  

  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

• Site Owners

  SSC Guru

  Points: 80320

  More actions

  March 1, 2023 at 6:10 am

  #4155313

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

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

• Emperor100

  SSCrazy

  Points: 2143

  More actions

  March 3, 2023 at 3:58 am

  #4156284

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

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

• durai nagarajan

  SSCoach

  Points: 15775

  More actions

  March 3, 2023 at 4:39 am

  #4156296

  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