Tim_Man
01-03-2005, 02:30 PM
I'd like to be able to import an XML file into an Access 2003 db using a web interface. Here's the scenario:
XML files will be generated from templates on client workstations. Clients will then go to a web page and be asked for the local XML file to upload. After the upload I'd like the file to be imported automatically into Access. How to do this? What kind of code do I need for this? Will FP2003 db hooks do this?
The reason I'm not using a straightforward form-to-db web page using FP webbots) is that the data to be filled out from the template is quite lengthy and the clients are dispersed around the world, meaning that ISP's are unreliable/intermittent and connect speeds are low. There's no way a sustainable connection could be maintained for the length of time needed to fill out a form.
Anyone have any other ways to do this?
Thanks,
XML files will be generated from templates on client workstations. Clients will then go to a web page and be asked for the local XML file to upload. After the upload I'd like the file to be imported automatically into Access. How to do this? What kind of code do I need for this? Will FP2003 db hooks do this?
The reason I'm not using a straightforward form-to-db web page using FP webbots) is that the data to be filled out from the template is quite lengthy and the clients are dispersed around the world, meaning that ISP's are unreliable/intermittent and connect speeds are low. There's no way a sustainable connection could be maintained for the length of time needed to fill out a form.
Anyone have any other ways to do this?
Thanks,