Programmatically Send Keyboard Input to Remote Desk Top 1

[BDazzler]

Here's the situation:
We are using an application hosted by another company via remote desk top. The application is data entry intesnive and repetative.

Much of the data is already in our database. Ideally we would send our vedor a datafile and they would import the information. They are unwilling/unable to commit the resources to the import.

I would like to be able to write a program that reads the data from our database, inserts it into a keyboard buffer at some point in the stream on our workstation, and have it sent, via RDC to their application.

I use VS 2005, primarily C#, but am perfectly willing/able to use C++ if necessary.

If anybody had done something like this, I'd love to have a discussion with you!

 

[ralphtrent]

the best thing to due would be to ask the vendor for an api that they can support if not longer the import process. Other then that, vbscript is a good way to "SendKeys".

 

[PatrickIRL]

Just another option...

If your client (and you) are using SQL Server then why don't you create a DTS to import the file into the database. You can test this yourselves before creating it for the client. This can be scheduled to run at intervals

Patrick

 

[BDazzler]

Thanks Patrick, in this case, my company is the client, and they (the vendor) are unwilling to commit the resources to do any addtional work on thier end for this product. I had a wonderful plan that used something just liket that. And they told us they could not (or would not?) commit the resources to making it work.

My boss told me to find another way. I figure it will involve SendKey, but I've not used SendKey for anything but very simple testing.