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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-08-31 : 19:19:00
|
| Ini writes "I am pulling data from a web page using a query string which allows me to specify parameters on the web page for the data I need. I am unable to access the database directly. Please can you advice on the best way to pull the data into an SQL table - DTS, XML? Any help would be highly appreciated.Thanks" |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-08-31 : 22:16:37
|
| I would use an XSL template to translate the HTML data (I assume it's some sort of table??) into XML or even CSV then you have several options on getting it into your database. If it's in CSV or fixed width you can BCP it in, or if it's XML you can read it by executing an OPENXML query. There are loads of ways you could do this, but XSL would be my preference because it's nice and clean and easily maintainable. But it could be a steep learning curve.... Alternately, you could simply write some VB script to manually parse the data and run it from inside a DTS ActiveX task. Depends on if you're a masochist or not.... :-)HTH,Tim |
 |
|
|
|
|
|
Importing HTML data to MS SQL Server