ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   To read from an Excel sheet using simple ASP (https://www.excelbanter.com/excel-programming/322704-read-excel-sheet-using-simple-asp.html)

Kurien Baker Fenn

To read from an Excel sheet using simple ASP
 
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.

Tim Williams

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.





All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com