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 |
|
gi_natale
Starting Member
3 Posts |
 Posted - 2013-01-07 : 15:34:51
|
| Hello Guys,I'm new with T-SQL/Microsoft and in this forum.I need somebody helps me, plz.I have two .html files saved(ftp) on a local server on daily basis.Those html. files contain a table report so that I need to move to SQL server 2008 DB only some columns.Questions: There is any way in order to do that?Thanks in advanceGN |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-08 : 00:02:51
|
| do you mean html files contain table data? or are they just reports for presentation?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
gi_natale
Starting Member
3 Posts |
Posted - 2013-01-08 : 08:31:21
|
[quote]Originally posted by visakh16
do you mean html files contain table data? or are they just reports for presentation?They just reports for presentation.ThanksGN |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-01-08 : 09:00:09
|
| Try parsing the html table through Powershell . And then connect to SQL Server to INSERT\UPDATE the dataJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
gi_natale
Starting Member
3 Posts |
Posted - 2013-01-08 : 13:54:21
|
quote:
Originally posted by jackv
Try parsing the html table through Powershell . And then connect to SQL Server to INSERT\UPDATE the dataJack Vamvas--------------------http://www.sqlserver-dba.com
Jack,Thanks for your answer.Any guide/link to follow?GN |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
Bulk in a SQL table pulling data from .html file