Back to all jobs

Ms access xml import  Add to shortlist

Client Details

STEVENSTEVEN V   
United Kingdom  United Kingdom
  • Member Since: Jul 2009
  • Last Login: 24 Sep 2009
  • Jobs Posted: 1
  • Jobs Awarded: 1
  • Paid out: $270

Job Details

Category:IT/Web/Programming > Database Development

ID:10420

Title:Ms access xml import

Location:Anywhere

Job Description

We require a VBA Module for MS to allow us to send an XML file (store as a memo field in an MS Access table) to an HTTPS gateway (variable).
Once the XML message has been sent, we then require the response to be stored in another memo field within the same record.
The table also includes the time the message was sent and the time the message was recieved.
This is part of an MS Access database that is currently in development. We have good knowlege of MS Access but are struggling with how to send and recieve XML to an HTTPS gateway.

Job Budget

Type:Per Hour

Budget:Not Specified

Additional Information

Attached Files: None

Bidding ends:Bidding Closed

Job Posted:12/08/2009 16:34

Bidding activity on this Job

Bids:10

Who has Bid:


View 7 more bids

Clarification Board

T. G.T. G. on 12/08/2009 17:54
Hi,
This is quite a complex issue using MS Access. I have managed to build something like this using VFP which is similar to Access and that was very involved too.
You might like to get your developers to attempt something similar to the approach that I took which involves creating a form with a hidden web browser control in it. This web browser control can be made to run an ASP page which can then call an asp page on the web server and this way you can pass data between the two web pages. This would allow communication in both directions which is what you need to pass your XML data and receive a response.
Hope this helps to stimulate a thought process with for your developers.

Cheers, Tony Green, Webography
M. R.M. R. on 13/08/2009 09:48
Hi,

This isn't too much of a problem for us as we are used to programming xml web service interfaces to allow recruitment agencies to post to various job boards.

Can I ask what is going to call the procedure? i.e. would this just be a case of providing a module and you will be hooking it in to your access system?

On a seperate note, which version of access are you using?

Thanks...
B. D.B. D. on 13/08/2009 10:53
What version of MS Access do you use. Its possible to use VBA for what you have described.

Bidding closed

Stay safe: Read our safety guidelines before bidding

Bidding has ended for this project, the client has accepted the bid(s) below:

Accepted Bid #1

Amount: $2 Per Hour

Country of Freelancer: United Kingdom  United Kingdom

Acceptance Reason: Jeff has already developed exactly what I need.

Estimated Start Date: Within 1 Business Day





Here are some practical tips on staying safe


Remember: if something looks too good to be true, it probably is!

If you are in doubt of the legitimacy of a Job and or Client, let us know by Reporting the Job.

For further support on preventing and reporting fraud please contact the UK’s National fraud reporting centre at http://www.actionfraud.org.uk/ or outside the UK Fraud Watchers at {fraudWatchers}