Read http stream with C#

[Guest]

I need to read an HTTP stream that is defined as excel format. How can I
access this via ADO.Net? This dataset pastes nicely into excel
http://ts-lc.sc8.finance.lycos.com/...=&Param2=&Param3=&FontSize=10&LocaleID=0x0409

Thanks in advance

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

I need to read an HTTP stream that is defined as excel format. How can I
access this via ADO.Net? This dataset pastes nicely into excel.
http://ts-lc.sc8.finance.lycos.com/...=&Param2=&Param3=&FontSize=10&LocaleID=0x0409

Thanks in advance

I'm not clear of what you want, especially that of a http stream as excel
format, what you mean with that?

You can use WebClient to get a http stream.

 

[Nicholas Paldino [.NET/C# MVP]]

Dan,

You are going to have to save the stream to a temporary file, and then
you can use the Jet provider for Ole Db to access the data in Excel.

 

[Guest]

The URL listed says this is in excel format. I want to read it into a C#
program.

 

[Guest]

I will need to read this file in C#. Still save this to a temporary holding
area then use ole db?

Dan,

You are going to have to save the stream to a temporary file, and then
you can use the Jet provider for Ole Db to access the data in Excel.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

I need to read an HTTP stream that is defined as excel format. How can I
access this via ADO.Net? This dataset pastes nicely into excel.
http://ts-lc.sc8.finance.lycos.com/...=&Param2=&Param3=&FontSize=10&LocaleID=0x0409

Thanks in advance

 

[Nicholas Paldino [.NET/C# MVP]]

Dan,

Yes, as Ignacio said, you would use the WebClient or the
HttpWebRequest/HttpWebResponse classes to do this, then you would access the
temp file through the Ole Db provider, as it requires a physical file.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

I will need to read this file in C#. Still save this to a temporary holding
area then use ole db?

Dan,

You are going to have to save the stream to a temporary file, and
then
you can use the Jet provider for Ole Db to access the data in Excel.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

I need to read an HTTP stream that is defined as excel format. How can I
access this via ADO.Net? This dataset pastes nicely into excel.
http://ts-lc.sc8.finance.lycos.com/...=&Param2=&Param3=&FontSize=10&LocaleID=0x0409

Thanks in advance

 

[Guest]

Thanks - I will go with this stategy.

Dan,

Yes, as Ignacio said, you would use the WebClient or the
HttpWebRequest/HttpWebResponse classes to do this, then you would access the
temp file through the Ole Db provider, as it requires a physical file.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

I will need to read this file in C#. Still save this to a temporary holding
area then use ole db?

Dan,

You are going to have to save the stream to a temporary file, and
then
you can use the Jet provider for Ole Db to access the data in Excel.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

I need to read an HTTP stream that is defined as excel format. How can I
access this via ADO.Net? This dataset pastes nicely into excel.
http://ts-lc.sc8.finance.lycos.com/...=&Param2=&Param3=&FontSize=10&LocaleID=0x0409

Thanks in advance