I'm trying to find out how to read an Excel spreadsheet and display the 
data using ASP.  Does anyone know how or where I can look to figure this 
out?  I've searched on the web a little and also in an ASP book 
unsuccessfully. -- thanks --

You should be able to use an ODBC connection to get to it, check out 
http://4guysfromrolla.com for more info.

At 02:16 07/04/02 +0000, you wrote:
>I'm trying to find out how to read an Excel spreadsheet and display the
>data using ASP.  Does anyone know how or where I can look to figure this
>out?  I've searched on the web a little and also in an ASP book
>unsuccessfully. -- thanks --
>
>---
>
>Improve your web design skills with these new books from Glasshaus.
>
>Usable Web Menus
>http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
>r-20
>Constructing Accessible Web Sites
>http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
>r-20
>Practical JavaScript for the Usable Web
>http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
>r-20

...Create an Excel Object...

<% Response.ContentType =3D "application/vnd.ms-excel" %>
and then u use the response.write method , the data will be displayed in
excel. It will prompt u whether to download the excel file or to open it
from current location. U choose the choice.

Eg.
   <%  Response.write  ("hai")  %>
     will now be displayed in excel.

   There is no need to put datas in the form to  excel sheet . whatever
u
typed in the form ,using the above said command will be displayed in
excel.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
...Presenting an EXcel page from an Access DB.....

    objAccess.TransferSpreadsheet acImport, 8[excel version],
"tableName",
"path-to-excel-file", False, ""

This should work for files on the same machine as the db...it converts
them
into tables directly, the False means the 1st row is data, if they're
field
names use True. Last param is cell/row range, empty is all.

-----Original Message-----
From: Phillip Conrad [mailto:phillip.conrad@f...]
Sent: Saturday, April 06, 2002 9:17 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Reading an Excel Spreadsheet using ASP


I'm trying to find out how to read an Excel spreadsheet and display the
data using ASP.  Does anyone know how or where I can look to figure this

out?  I've searched on the web a little and also in an ASP book
unsuccessfully. -- thanks --

---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
r-20

This "HOWTO" came in handy in completing what I needed to...
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q195951