Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: ASP example to query excel spreadsheet data

Results 1 to 3 of 3
Share This Thread →
  1. #1
    markoc's Avatar
    markoc is offline Contributing User
    Join Date
    Nov 2003
    Location
    UK
    Posts
    2,280
    Rep Power
    310

    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.
    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
    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

  3. #3
    Alethea55 is offline Registered User
    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.

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