Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
xclaim
Starting Member
8 Posts |
Posted - 2013-03-10 : 19:33:00
|
HiIm trying to read a html file directly into the sql db.Is that possible ?are there any parsers out there i can use ?same file is at :http://qfs.mobi/downloadCached.ashx?k=1078ce659fbc43e3b3836ced9051491e&f=434503i'm trying to add the table that begins with "strike" as columns and all the others as well. I need the actual data input into sql not the html code.Thanks in advance. |
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-03-11 : 11:49:45
|
There are a few parser scripts around written in Powershell. They will take a html file and clear out the html code. From there you can place them in an object and pass through to a SQL Server tableJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2013-03-11 : 20:54:17
|
I probably wouldn't do this in the database, but if pushed, I'd have a crack at loading the HTML into an XML type then use XML functions to pull it apart. |
|
|
|
|
|