Access excel file in HttpPostedFile directly?

[Ralph Watermann]

Hi,

we upload an Excel-file via a FileUpload-Control into an HttpPostedFile
object.
Now we want to access the contained data directly without saving it to a
temp file. Is this possible?

So far we have to to a HttpPostedFile.SaveAs(strFileName) and use a
connection string to access the data via an OleDbDataAdapter:
strConn = _

"Provider=Microsoft.Jet.OLEDB.4.0;" & _

"Data Source= " & strFileName & ";" & _

"Extended Properties=""Excel 8.0;"""

But we don't really want the ASP.NET program to have write access to any
directory on the Server.



Kind regards,

Ralph

 

[Mark Rae]

Now we want to access the contained data directly without saving it to a
temp file. Is this possible?

I don't believe so... every connection string for Excel I've ever seen needs
a physical file to open - I don't believe it can use one of the MemoryStream
/ FileStream objects in the System.IO namespace...

http://www.connectionstrings.com/?carrier=excel
http://www.connectionstrings.com/?carrier=excel2007