+ Reply to Thread
Results 1 to 2 of 2

To read from an Excel sheet using simple ASP

Hybrid View

  1. #1
    Kurien Baker Fenn
    Guest

    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. #2
    Tim Williams
    Guest

    Re: 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" <KurienBakerFenn@discussions.microsoft.com> wrote
    in message news:9AA5492A-6117-4053-8045-A24BD5B007E5@microsoft.com...
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1