Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jun 2003
    Location
    Utah, USA
    Posts
    412
    Thanks
    39
    Thanked 5 Times in 5 Posts

    Export to a Web Form (2003 SP2)

    I can't control either end of this process, and I'd like to automate it.

    1) I will be receiving data in spreadsheet form from multiple users. It will essentially be a naive database - labeled columns, user entries in rows.
    2) I need to get the data into a form on a website. One row from the spreadsheet to a form, each element from the row going into its own input box on the webpage.

    How do I automate this without going nuts cutting and pasting it all by hand?

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Export to a Web Form (2003 SP2)

    Do you have, or can you get, any access to the database (I'm assuming there is one)behind the web form? It would be much easier to bypass the form altogether if at all possible, but without knowing more about your circumstances, I can't say how viable that is.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    4 Star Lounger
    Join Date
    Jun 2003
    Location
    Utah, USA
    Posts
    412
    Thanks
    39
    Thanked 5 Times in 5 Posts

    Re: Export to a Web Form (2003 SP2)

    No.

    That's why I posted.

    I am sandwiched between two groups that have always done it this way and don't want to change - they would rather have someone expensive (me) type this by hand because they're not actually the ones paying for my time.

    What are you driving at? Something along the lines of could I obtain the POST or GET string that the form submits? That might be easier to get hold of ...

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Export to a Web Form (2003 SP2)

    I've been the filling in that sandwich myself a few times. <img src=/S/doh.gif border=0 alt=doh width=15 height=15>
    If you could get any sort of access to the db, then using ADO to add the data would be simplest (assuming there is a suitable provider). If you can't, but the form posts using a script that takes set parameters, then you should be able to build the right string up from each row of data and use that. Alternatively, try and find someone important who might like the concept of saving some money and be willing to adapt the way things have always been done... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    4 Star Lounger
    Join Date
    Jun 2003
    Location
    Utah, USA
    Posts
    412
    Thanks
    39
    Thanked 5 Times in 5 Posts

    Re: Export to a Web Form (2003 SP2)

    Oh well - I was hoping there was some connection between Excel and IE that I could take advantage of.

    I'll start making phone calls on Monday.

Posting Permissions

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