SQLTeam.com | Weblogs | Forums

Get data from a website directly into SQL table?

Hello.

This is the website

UK Government

It's the table on that page (has approx 1.7 million rows)

Hello

You cant import directly. For one thing the data is paginated

image

You might have to use some scripting language like powershell or python, to paginate and get the data.

2 Likes

There is an export button to export it to csv. Here's the url you can used to download csv file

https://opendata.camden.gov.uk/api/views/77ra-mbbn/rows.csv?accessType=DOWNLOAD

also a how-to get it using ADF

1 Like