#1
  1. Contributing User
    ASP Hero (2000 - 2499 posts)

    Join Date
    Nov 2003
    Location
    UK
    Posts
    2,280
    Rep Power
    311

    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
    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
  3. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 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
  4. #3
  5. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Nov 2013
    Posts
    1
    Rep Power
    0
    idea is outstanding the issue is one thing that not enough persons are speaking intelligently about. I am very completely satisfied that.

Similar Threads

  1. ERROR [IM002] When reading Excel Spreadsheet
    By jobo in forum .NET Development
    Replies: 8
    Last Post: March 24th, 2005, 06: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, 09: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, 06:24 PM
  4. Crosstable query returns too many records
    By Palsam in forum ASP Development
    Replies: 7
    Last Post: March 12th, 2004, 09:07 AM

IMN logo majestic logo threadwatch logo seochat tools logo