Hi all, we need to be able to connect to an Excel in a remote server
via ADO.NET.

We have a component that makes queries to that excel a retrieves the
data requested, but when we are trying to get the data from the remote
excel we can´t connect because we have an URL and not a physical path.

Any idea?


thanks in advance

Julio

Mmm...

  Is the excel spread sheet quite big? One possiblity could be to download 
the sheet from your site and then read it locally, you can use WebClien class 
to do that:

http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=115

  On the other hand if what you are looking for is to use the Excel 
calculation engine and let your client define his calculation in a excel 
sheet, you could use "Excel services" (running excel spreadsheets on a 
server):

http://blogs.msdn.com/excel/archive/2005/11/08/490502.aspx

Good Luck
       Braulio

/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------




"jcotroneo@gmail.com" wrote:


> Hi all, we need to be able to connect to an Excel in a remote server
> via ADO.NET.
> 
> We have a component that makes queries to that excel a retrieves the
> data requested, but when we are trying to get the data from the remote
> excel we can´t connect because we have an URL and not a physical path.
> 
> Any idea?
> 
> 
> thanks in advance
> 
> Julio
> 
>