SQLTeam.com | Weblogs | Forums

Import HTML table into SQL


#1

Hi there,

I'm new to SQL, I receive timesheet data from a webpage that contains a table which i analyze in excel but i dont know how to convert the html data into excel keeping the format. I tried the built in web query in excel but it clusters the entire table into a single column which is no good. I was thinking maybe there's way i can import the html table into SQL then export to excel but i dont know how, please assist?

Thanks in advance


#2

#3

Thanks but i saw this article and it doesn't help me much as i dont have the tenchnical skills to use HAP with powershell. Isn't there a simpler way or any other way i can import html table into excel without changing the format?