import data from internet into database

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 2005 Forums

SSIS and Import/Export (2005)

import data from internet into database

Author

Topic

jensmens
Starting Member

3 Posts

Posted - 2010-08-17 : 15:31:41

hi,

i just started experimenting with import and export from data.
now, i wondered if it is possible to take data from a website and put it directly into a database. and is it also possible to filter the data:)

as exemple a code;

<div class="info-container">
		<h2><span class="playlistnoa">17:25 Now Playing</span><span class="playlistplay">Playlist - 17:25</span></h2><div class="song-name">
										<a href="/mnmtheek/song/2636" title="Escape" onclick="mnm.mnmtheek.add('Escape - ENRIQUE IGLESIAS', 'Escape', 2636, 'song', '', 'mnmtheek.lied.escape'); return false;">Escape</a>
									</div>
									<div class="artist-name">
										<a href="/mnmtheek/artist/1072" title="ENRIQUE IGLESIAS" onclick="mnm.mnmtheek.add('ENRIQUE IGLESIAS', 'ENRIQU', 1072, 'artist', '', 'mnmtheek.artiest.enrique-iglesias'); return false;">ENRIQUE IGLESIAS</a>
									</div><div class="muziek-buttons-placeholder">

how can i get the data 'enrique iglesias' and 'escape' ? :)

hope that someone could give me a hint or a link that could help me:)
sorry for my bad english!

greets!

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-08-17 : 16:17:29

you want help screen scraping someone's web site? let me ask you this, do you have their permission? and if so, why not just ask 'em for the content directly?

jensmens
Starting Member

3 Posts

Posted - 2010-08-17 : 16:45:36

no, i just wondered if it's possible, because i read a lot about input data, but never read something about import directly from a hmtl or xml file ( like a website)?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-08-17 : 21:13:52

you're better off writing an application in your favorite programming language to parse the HTML. yes, it CAN be done in T-SQL, but I wouldn't recommend it

jensmens
Starting Member

3 Posts

Posted - 2010-08-18 : 03:01:50

Ok, thanks for your advice, i'll try to parse the Html !

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources