Thread: ASP example to query excel spreadsheet data

Results 1 to 2 of 2
Share This Thread →
  1. #1
    markoc's Avatar
    markoc is offline Contributing User ASP Free Regular (2000 - 2499 posts)
    Join Date
    Nov 2003
    Location
    UK
    Posts
    2,280
    Rep Power
    309

    ASP example to query excel spreadsheet data

    I have attached some asp example pages to query an Excel spreadsheet to retieve data and display the results. first one displays the results in a table and the second page creates a dynamic combobox with a onchange event to get the details of the selected name.

    There is also a word doc to explain how to create the excel file so you query it with a SQL statement.

    All the Best.
    Comments on this post
    • nofriends → agrees!
    • Shadow Wizard → agrees: excellent :)
    • lewy → agrees: Nice :tblue:
    • pws1970 → agrees!
    • mehere → agrees!
    • micky → agrees!
    • RadioactiveFrog → agrees!
    • elijathegold → agrees!
    • Rebelle → agrees: very cool!
    Attached Files Attached Files
    Hope this advise helps.

    If so please show your appreciation by adding reputation points (click gauge image on top right of this post and score).

  2. #2
    captain jack is offline Registered User ASP Free Newbie (0 - 499 posts)
    Join Date
    Jan 2013
    Posts
    1
    Rep Power
    0
    Hai,

    im jus a newbie in ASP and i gotta do something like you jus shown.
    I read the read me and im stuck at this step:

    One this is all done, just add a page in the root of the web server to point the default page in the directory:
    excel_db/default.htm

    can u please explain it to me?

    Thank you

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

Similar Threads

  1. ERROR [IM002] When reading Excel Spreadsheet
    By jobo in forum .NET Development
    Replies: 8
    Last Post: March 24th, 2005, 05:14 PM
  2. Create an ASP to veiw data from an Excel Spreadsheet
    By blingsingh in forum ASP Development
    Replies: 1
    Last Post: February 21st, 2005, 08:10 AM
  3. Need help using Access query data to fill a Microsoft Word document
    By passmaster16 in forum Microsoft Access Help
    Replies: 2
    Last Post: July 19th, 2004, 05:24 PM
  4. Crosstable query returns too many records
    By Palsam in forum ASP Development
    Replies: 7
    Last Post: March 12th, 2004, 08:07 AM

ASP Free Advertisers and Affiliates