Get data from an html page into DB SQL Server

Question

Hello everyone,

I was wondering if it's possible to get data from an html page and load it to a DB (Postgres, SQL Server) directly. If it's impossible to do it directly, which is the best way or easiest one to do it?

What i want to get and store, is the release date from the first column of the page https://sqlserverupdates.com/sql-server-2016-updates/

TY for ur time :D

Answer 1

Hi RicardoAnselmoOliveira-7430,

Please take a look at the following articles which might help:
https://www.red-gate.com/simple-talk/databases/sql-server/learn/how-to-import-data-from-html-pages/
https://www.c-sharpcorner.com/article/data-scraping-from-a-website-and-save-to-sql-server-using-uipath-rpa/

Best Regards,
Amelia

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

It should be possible, e.g. with a .NET application using Html Agility Pack (HAP) to parse the web page to get the data from the HTML table; but it's nothing you could solve directly on MS SQL Server side.