Create Visual Basic Function to export Access Table to XML
Budget: £20 – £250 GBP
We need to provide a date feed to Klevu for a search engine on our website, we have the data inside a Microsoft Access Table and we need a function writing in VBA that can export this data in the correct XML format.
The Klevu XML format can be found in the link below however our data requirement is a lot simpler than in their sample.
https://github.com/klevu/feed/blob/master/sample.xml
https://github.com/klevu/feed/blob/master/schema.xsd
I've made a video with full details:
https://screencast-o-matic.com/watch/c3h1iwVY9Z0
You will be provided with a copy of an Access database containing the data.
We need a function within the Access database that we can run to export the data when we require to update it, the XML file should be stored on the local PC.
Any questions please let me know.
The Klevu XML format can be found in the link below however our data requirement is a lot simpler than in their sample.
https://github.com/klevu/feed/blob/master/sample.xml
https://github.com/klevu/feed/blob/master/schema.xsd
I've made a video with full details:
https://screencast-o-matic.com/watch/c3h1iwVY9Z0
You will be provided with a copy of an Access database containing the data.
We need a function within the Access database that we can run to export the data when we require to update it, the XML file should be stored on the local PC.
Any questions please let me know.