Forum Discussion
Extracting Data from a protected website
hi collinq , I am using web and this URL has the web form created in asp.net language and this web form has multiple fields or drop downs , i am working on extracting all the tables , fields everything (historical data) by creating a live connection between them.
Hi Harpreet1405_12 ,
I think that the best method is going to get the data out of the system that is producing this web page. This is output from those tables and is put together but I think it would be very difficult to try and get the data out of what you are looking at based on the screenshot.
You will need to find the underlying tables (based on the screenshot - the ones in the SIS system itself) and then you can put together this report and other ones yourself quite easily since you will have the original data to link and create slicers from.
Thank you so much collinq for your time and response... Do you think excel would be the only option to maintain these tables in database?
Hey Harpreet1405_12 ,
Excel is a great tool for holding unstructured date (or exports of structured data) but it really shouldn't be considered a "database". I think your best bet is getting to the original data because that is going to the best maintained and current data.