How to import XML file into Access 2002?

[Sean]

Hi All,

Scenario:
I have a A.xml file containing the following format.
<tblA>
<AID>1</AID>
<tblA>

How do I import it into a tblA table in dbA.mdb?

Thanks in advance. =)


Regards,
Sean

 

[One Handed Man \( OHM - Terry Burns \)]

Use the DataSet XMLRead method.

MyDataSet.XMLRead("Your XML File Path and Name.xml")

--

OHM ( Terry Burns )
. . . One-Handed-Man . . .

Time flies when you don't know what you're doing

 

[One Handed Man \( OHM - Terry Burns \)]

sorry that should have been

ds.ReadXml("MyXML.xml")


--

OHM ( Terry Burns )
. . . One-Handed-Man . . .


Time flies when you don't know what you're doing