SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Bulk in a SQL table pulling data from .html file
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gi_natale
Starting Member

USA
3 Posts

Posted - 01/07/2013 :  15:34:51  Show Profile  Reply with Quote

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

India
52317 Posts

Posted - 01/08/2013 :  00:02:51  Show Profile  Reply with Quote
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

USA
3 Posts

Posted - 01/08/2013 :  08:31:21  Show Profile  Reply with Quote
[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
Flowing Fount of Yak Knowledge

United Kingdom
2042 Posts

Posted - 01/08/2013 :  09:00:09  Show Profile  Visit jackv's Homepage  Reply with Quote
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

USA
3 Posts

Posted - 01/08/2013 :  13:54:21  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2042 Posts

Posted - 01/11/2013 :  10:27:12  Show Profile  Visit jackv's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.16 seconds. Powered By: Snitz Forums 2000