Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004

    Unanswered: Pulling data from Excel into ASP

    Hi there,

    How to pull the data out from Excel into ASP which the data from Excel can and will be displayed inside textbox so that i can manipulate the data after that?

  2. #2
    Join Date
    Nov 2003
    Christchurch, New Zealand
    you' d have to use the Excel object to do it,.. something on this page should point you in the right direction...

  3. #3
    Join Date
    Jun 2003
    You can connect to a csv file (which can be opened in Excel and which an Excel file can be converted into) in good form just as you can to a regular database.

    The .csv file needs to be uploaded to the server.

    And for help connecting to a text file using the Jet OLE DB provider:

    And based on the above link realize that the actual filename does NOT go in the connection string - rather it goes in the SQL statement (definitely a little tricky).
    J. Paul Schmidt, Freelance Web and Database Developer
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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