Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Toronto, Ontario, Canada
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Import to web (Excel 2003)

    I am running an XML/ASP based web application and I'd like to give users the ability to import a completed Excel form and have a web form within the application grab values out of the xls file. The cell references would be static. A CSV import would not work in this case.
    Can anyone refer me to an information page or source code related to this?
    Thanks,

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Import to web (Excel 2003)

    The ADO drivers can read ordinary row and column data from an XLS file, but if it's laid out in a form, that presents some challenges. Microsoft generally recommends against automating Office applications on a server, at least with respect to Access, perhaps because it is difficult to predict the different prompts or other circumstances that could arise in doing so.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Toronto, Ontario, Canada
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Import to web (Excel 2003)

    All the data contained within the Excel form is in cells, not controls.

Posting Permissions

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