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 |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2006-10-06 : 09:14:52
|
| I need to create a app to read data in URL and then save into a table.Below is URL:http://test.com/PivotHealth/tracking.php?Course=HIPAA%20-%20Privacy&ID=0&FirstName=Andrew&LastName=Duthie&Position=Staff&Facility=Tusculum%20Pediatric,%20Inc.&Status=completed&CompletedDate=10/3/2006When you open this URL, data will display as below:(I change company name. You will not open it)Success, wrote (HIPAA - Privacy, 0, Andrew, Duthie, Staff, Tusculum Pediatric, Inc., completed, 10/3/2006 ) to file (trackingdata.txt)I need (HIPAA - Privacy, 0, Andrew, Duthie, Staff, Tusculum Pediatric, Inc., completed, 10/3/2006) to save in a table. Each column data was separated by ",". For exaple, Andrew will store in "FirstName", Duthie will store in "LastName"Can someone help me? |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-06 : 10:07:57
|
| You could use the MSXML2.ServerXMLHTTP.4.0 object to scrape the page, and then parse it and squirt the data you want to keep into your database table.Kristen |
 |
|
|
|
|
|
|
|
read URL data