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

    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?
    thanx

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

    http://msdn.microsoft.com/library/de...celObjects.asp

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    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:
    http://www.able-consulting.com/MDAC/...crosoftJetText

    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
    www.Bullschmidt.com
    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
  •