Parsing data from an HTML website

Question

Hello,

We have a requirement to get some data from this website into a table. 

http://www.pfizer.com/HCPDisclosureWebApplication/jsp/payments_report.jsp?enPdNm=ALL

Has anyone worked on a project like this before? I know there is a big chance some code need to be written, and with my limited programming experience I was hoping for some recommendations.

Thank you

---

Abdallah El-Chal, PMP

Answer 1

the table row is diveded over multiple html rows so you can't just read it as some textfile and remove the html tags. So you're probably right about writting some .Net code. There are libraries for this that could make things easier: http://htmlagilitypack.codeplex.com/wikipage?title=Examples and http://int.social.msdn.microsoft.com/Forums/hu-HU/winforms/thread/9c645585-0635-42fe-9739-e57384e99e19

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 2

Thank you. 

---

Abdallah El-Chal, PMP