View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default To read from an Excel sheet using simple ASP

If the data is arranged in a tabular format you can use ADO and the
Excel driver to query it as if it were a database table.
Plenty of references on the web - google for Excel+ADO+ASP
Eg: http://support.microsoft.com/kb/q195951/

If the data format is irregular then you'l have to use ASP to automate
excel and extract the data cell by cell

Tim.


"Kurien Baker Fenn" wrote
in message ...
Hello,
I have an Excel sheet which resides in my D: drive. I have to
access
this excel sheet and read the data from it and print it on an ASP
page.This
all should be done using simple ASP.Please help me.
Thank You.