Populating Fields on a Webpage

[BrianB75]

I wasn't sure where I should have posted this question so please feel free to move it if necessary.

I am not even sure this is possible and I didn't know where to begin but these forums have always been extremely helpful.

What I would like to do is export data directly from Access (via form, table or query) and populate it directly to an existing, external webpage.

A little background. My company orders cars an for certain manufacturers, Toyota for example, we order via a secure website. All of the other manufacturers have their order directly transmitted to them. The orders for Toyota take 3-4 times longer to place and I was hoping to speed the process by exporting existing order information directly to the webpage.

Please let me know if it seems like I am smoking something and I will gladly step away from the pipe....=)

Thanks in advance,
Brian

 

[FoFa]

It's totally possible to do this, using SENDKEYs or processing the HTTP pages directly (via VBA). The downside how ever is you are at their mercy and their development on their web pages. One small change and yours fails. Also the error checking would be complicated. Have you checked with them to see about processing XML or EDi as an example?

 

[BrianB75]

XML is a possibility as we are using it currently for GM, Chrysler and Ford but Toyota, Mazda and a few others are not as Fleet based as their American counterparts.

Since this is uncharted territory for me do you have an examples of the code or an idea where I might find some. I am assuming that I would set the variables in the code from the database object and use the SENDKEY to export it to the HTML page. Since I would like to prototype this quickly I guess I could just search the source code for the page while waiting on an answer from Toyota directly.

Any examples/pointers would be greatly appreciated. Thanks again. I'll post back if I make any progress.

Thanks,
Brian

 

[BrianB75]

Also to clarify, what I want to do is export stored data from a table in Access to a webpage. Basically take the data in Field A in the table and copy it into Field A on the webpage.

Thanks again
Brian

 

[FoFa]

SENDKEY will do that, but you have to think of using SENDKEY as you were sitting there typing in the information. Including tabbing etc. It is a complicated process, even though it seems easy initially.