Access excel file in HttpPostedFile directly?

R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top