Transfer data to web page fields

Can anyone help me to transfer data results from a SQL query to
input forms on a web page using vba or whatever will work. I work
on a web page with forms that I need to populate with data. The web
page is not mine and I have no control of the web page. My data
comes from an SQL query and I want to code the transfer of the
multiple data results into the web page form fields. I have little
experience with VBA and SQL so please comment any code if possible.
Thanks for your help.
Jman


--
--------------------------------- --- -- -
Posted with NewsLeecher v3.7 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

Re: Transfer data to web page fields

On Thu, 31 Jan 2008 18:57:56 GMT, jman (jcnone@none.com) wrote:

That's not quite the subject of this newsgroup, but I will try to
answer. It's not a simple project, and someone with "little
experience" will likely not be able to complete it.
If you want to use VBA you could create an Access form, have a
webbrowser control on it, and in code (or via a textbox) navigate to
your webpage. Then you need to use the DOM = Document Object Model to
find the input boxes and put values in them. E.g.:
WebBrowser1.Document.All("some_field").innerText = some_value
Getting the data out of the sql server is the easy part. You'd
probably run a query and capture the results in an ADO recordset.
You can also submit the page by calling the submit button's click
event:
WebBrowser1.Document.Forms(0)("Submit").Click

If the above is too much for you, hire professional help. "Microsoft
Solution Provider" in your Yellow Pages is a good place to start.

-Tom.


>Can anyone help me to transfer data results from a SQL query to
>input forms on a web page using vba or whatever will work. I work
>on a web page with forms that I need to populate with data. The web
>page is not mine and I have no control of the web page. My data
>comes from an SQL query and I want to code the transfer of the
>multiple data results into the web page form fields. I have little
>experience with VBA and SQL so please comment any code if possible.
>Thanks for your help.
>Jman

Re: Transfer data to web page fields

Tom,
Thanks for your reply.
Do you know of a group where this topic would be more suitable?
I will see what I can do with the outline you provided. Any coding
examples, links, tutorials you may know of which use the outline you
gave to transfer data from an SQL query to a web form field would
be much appreciated.
Thanks
Jman


--
--------------------------------- --- -- -
Posted with NewsLeecher v3.7 Final
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -