How do I bulk insert a datastream online?

[James Shao]

How can I use the bulk insert function with an online stream of data? Can I simply do: Bulk Insert datatable From 'http://www.websites/sample.txt' or Do I need to create a webclient, wrap it with a reader/writer (assuming "sreader") and do: Bulk Insert datatable From 'sreader' Thanks!

[T2102]

You may find examples already built using google, especially for yahoo stock data