Export to a Web Form (2003 SP2)

Topic

New Reply

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?

Reply | Quote

Replies

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.

Reply | Quote

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 …

Reply | Quote

I’ve been the filling in that sandwich myself a few times.
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…

Reply | Quote

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.

Reply | Quote