C
chris
I have read online that it is possible to import XML data
into Access2002, but is there a way to import it into
Access2000?
into Access2002, but is there a way to import it into
Access2000?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Joe Fallon
I just took a quick look.
Does not look like it.
However, I did it in A97 by writing my own custom import xml function.
It is a huge pain to write though.
A2003 has the best support for xml.
If you need xml then go with A2003.
Does not look like it.
However, I did it in A97 by writing my own custom import xml function.
It is a huge pain to write though.
A2003 has the best support for xml.
If you need xml then go with A2003.
G
Guest
I have the same need. I tried A2002 and it did not work well. I got and will be installing A2003, as that is the version the person who gives me the XML file is using also
Then, I will have to save it (or 2003 lets you determine which ver you want to work with as your default) back to A2000, export those imported tables into my A2000 working mdb
I wrote some code to empty the tables and then update them. I will issues with my relationships, RI, and cascading, which I have to work out
mdm
Then, I will have to save it (or 2003 lets you determine which ver you want to work with as your default) back to A2000, export those imported tables into my A2000 working mdb
I wrote some code to empty the tables and then update them. I will issues with my relationships, RI, and cascading, which I have to work out
mdm
G
Guest
I had to do the same thing
I installed A03, opened my a2000 mdb in A03 and with an import form I created, emptied my tables, and then did a manual File|Get External Data| type XML, and chose append to existing tables in the option button, and brought them right in
Since I was in A2000 format, there is no saving or converting. Just close A03, and open the mdb in A2000
Evidentally, The Application object has an ImportXML method that'll let you do it, so I am going to code it later
md
I installed A03, opened my a2000 mdb in A03 and with an import form I created, emptied my tables, and then did a manual File|Get External Data| type XML, and chose append to existing tables in the option button, and brought them right in
Since I was in A2000 format, there is no saving or converting. Just close A03, and open the mdb in A2000
Evidentally, The Application object has an ImportXML method that'll let you do it, so I am going to code it later
md