Hi,
Does anyone know the procedure to store the data from the xml into an existing access database.
Printable View
Hi,
Does anyone know the procedure to store the data from the xml into an existing access database.
Are you talking about how do you convert it? Because if that's what you mean, you shouldn't have to convert it. XML is supposed to be a universal coding similar to HTML, meaning it would be completely platform independant and also program independant. So you shouldn't need to convert it, that is assuming MS did a good job creating XML! :D
------------------
Ryan
I don't want to convert the data. I want to import the dat from the XML file into the access database.
I don't want to convert the data. I want to import the dat from the XML file into the access database.
Just open it and read it like any other text file, and store it in a text/memo field.
XML documents are all text, no binary, so it should be pretty simple
HTH
Tom