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.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Bulk in a SQL table pulling data from .html file

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 advance


GN

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

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.
Thanks

GN
Go to Top of Page

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 data

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

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 data

Jack Vamvas
--------------------
http://www.sqlserver-dba.com



Jack,
Thanks for your answer.

Any guide/link to follow?



GN
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2013-01-11 : 10:27:12
GN , two useful links :
http://htmlagilitypack.codeplex.com/ - this link points you to a very versatile html page scraping powershell extension
http://www.sqlserver-dba.com/2013/01/sql-server-export-excel-data-to-sql-server-with-powershell.html - this link takes data from an Excel spreadsheet and bulk inserts into a SQL Server database .

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -