Access Excel File After Upload to Web Server Memory

[Jack Harrington]

Using a web form with an input field of type "file", is there a way to
upload an Excel .XLS file into the web server's memory, access a sheet, and
copy the data into an ADO.NET DataSet without saving the .XLS file to the
server's hard drive? In other words, access the .XLS file while it's in the
server's memory as if it resided on the hard drive.

Thank you !!
Jack H.

[bill]

I think you can save it to disk, read it to memory, then delete it.

Jack Harrington wrote:

Using a web form with an input field of type "file", is there a way to
upload an Excel .XLS file into the web server's memory, access a sheet, and
copy the data into an ADO.NET DataSet without saving the .XLS file to the
server's hard drive? In other words, access the .XLS file while it's in the
server's memory as if it resided on the hard drive.

Thank you !!
Jack H.

--
bill
e-mail: bi*****@hotmail .com
MSN Messenger: bi*****@hotmail .com
Web: http://www.minivoice.com

[Natty Gur]

Hi,

Hi, you can use "Request.Fi les[0].InputStream" to read the file content
into byte array and update the data set.

refer to :
support.microso ft.com/default.aspx?kb id=308042

Dim ds As DataSet = New DataSet()
pAdapt.MissingS chemaAction = MissingSchemaAc tion.AddWithKey
pAdapt.Fill(ds, "UploadTabl e")

Dim row As DataRow
row = ds.Tables("Uplo adTable").NewRo w()

byte[] arrByte = new byte[Request.Files[0].InputStream.Le ngth] ;
Request.Files[0].InputStream.Re ad(arrByte,0,
(int)Request.Fi les[0].InputStream.Le ngth);

row(0) = Request.Files[0].FileName
row(1) = arrByte

ds.Tables("Uplo adTable").Rows. Add(row)
pAdapt.Update(d s, "UploadTabl e")
pConn.Close()
Natty Gur[MVP]
Phone Numbers:
Office: [phone]
Fax: [phone]
Mobile: [phone]
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Steve C. Orr [MVP, MCSD]]

Here are some links that can help you:
http://www.aspnetpro.com/NewsletterA...200309so_l.asp
http://www.aspose.com/Products/Aspose.Excel/
http://officewriter.softartisans.com/

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
Hire top-notch developers at http://www.able-consulting.com

"Jack Harrington" <jh***********@ cox.net> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..

Using a web form with an input field of type "file", is there a way to
upload an Excel .XLS file into the web server's memory, access a sheet, and copy the data into an ADO.NET DataSet without saving the .XLS file to the
server's hard drive? In other words, access the .XLS file while it's in the server's memory as if it resided on the hard drive.

Thank you !!
Jack H.