Hi.
I’m a complete XML newbie (reading “Sam’s Teach Yourself XML in 21 days” as I type).
I have spent days perfecting my database in Access 2000. I now have to export a simple "end result" table to XML using a schema that has been provided. (All the hard work is done appending data to this table and it is ready to go).
I know that Access 2000 does not natively support XML. I would like to know any recommendations that anyone has regarding some middleware that will make this export as straightforward as possible. I’d like to export the data of a table into XML that is completely compliant with the provided schema. This db will probably be upsized to SQL soon and I would need to export regularly.
Thanks for any advice.
I’m a complete XML newbie (reading “Sam’s Teach Yourself XML in 21 days” as I type).
I have spent days perfecting my database in Access 2000. I now have to export a simple "end result" table to XML using a schema that has been provided. (All the hard work is done appending data to this table and it is ready to go).
I know that Access 2000 does not natively support XML. I would like to know any recommendations that anyone has regarding some middleware that will make this export as straightforward as possible. I’d like to export the data of a table into XML that is completely compliant with the provided schema. This db will probably be upsized to SQL soon and I would need to export regularly.
Thanks for any advice.