February 28, 2023 at 5:17 am
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
March 1, 2023 at 6:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
March 3, 2023 at 3:58 am
Python is used heavily for web scraping, you should give it a try using it to extract the data between the html tags.
=======================================================================
March 3, 2023 at 4:39 am
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