I am looking for some help. listed here is a description of what i am trying to do ..
1 using database access 2007.
2 based on specific fields in current database
3 goto specified web site and sign in.. once done select from drop down box on website a specific selection.. wait for new window to come up.. click a link.. wait for new window..
4 input data in web page from field in database
5 retrieve specific data from webpage after updat..
6 store that data into current database in specific fields..
.. IF you can help with this.. please email me or post here..
Thanks
The scenerio should be:
1. Extract your data and prep your upload file in the specified format (May include saving to a specific folder or drive and may include encryption). (Your step 1 and 2 is combined here)
2. Do your step 3
3. If it is single record entry, enter the info and press ok/accept, else your business partner should have the ability (and functionality) in the site to accept upload file.
4. If it was single entry, partner site will check validity of entry and return an accept/retry/fail. If multiple records, partner site will import upload file (in the specified format), check formatting, check data validity, parse and process data, and return a result dataset to the page with the ability to save/download results in a prespecified format.
5. If all was successful to this point you will have a download file to import in your database for processing and storage.
I have done a lot of projects for major corporate clients as a developer and business systems analyst. At a minumum, you and your business partner should be exchanging records via ftp or https. Some banks I have dealt with have software packages which will allow you to login and upload/download files. I work for an insurance company now and we are exchanging data with state and federal govt entities, insurance agents, customers, vendors, and other entities.