I am about to start work on creating an XML feed form my Access app. Is my general understanding of how this works (below) correct?:
1. Create an XML file from Access - essentially a text file with XML fields etc.
2. Append or upload this to a web server.
3. Refresh after some pre determined time interval ad infinitum.
I know this is an extreme simplification but is this essentially correct? If so and I want to append or upload to a site - how would you best do this? I could do a simple FTP upload for new files. I could also download - append - then upload - but I feel there should be a neater way of directly appending to a web location. If someone can point me in the right direction that would be ace.
Apologies for my basic understanding.
I am using 2010.
1. Create an XML file from Access - essentially a text file with XML fields etc.
2. Append or upload this to a web server.
3. Refresh after some pre determined time interval ad infinitum.
I know this is an extreme simplification but is this essentially correct? If so and I want to append or upload to a site - how would you best do this? I could do a simple FTP upload for new files. I could also download - append - then upload - but I feel there should be a neater way of directly appending to a web location. If someone can point me in the right direction that would be ace.
Apologies for my basic understanding.
I am using 2010.
