Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to read the data from -- Excel sheet Manmohan Singh Excel Worksheet Functions 1 January 16th 07 07:02 AM
how to read the data from Excel sheet Manmohan Singh Excel Worksheet Functions 0 January 15th 07 01:14 PM
Can Excel 97 read Excel 2003 simple spreadsheet? MSfStl Excel Discussion (Misc queries) 3 November 21st 05 07:08 PM
To Read from an Excel sheet Kurien Baker Fenn Excel Programming 0 February 8th 05 02:51 PM
How to read Excel Spread Sheet in VB Shabnam Gupta Excel Programming 3 October 16th 03 06:41 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"