Transfer data from MS Access to XML

Sunitha Padmasri Pamart

The text of this article is not in this database — only its details are. The old site it was published on is gone, but the Internet Archive kept a copy: Transfer data from MS Access to XML

CREATE XMLAccess to XMLMS Access to XMLTransfer from MS Access to XML

6 Comments

Join the conversation! Your thoughts help the community grow.

Meas Dymong15y ago
Hello everybody i would like to ask you about replace two string into one textbox to number. eg. i have txt1=$ 1,200. i want in txt1=1200. how can i do if want it in function?
cone first16y ago
i am a beginner in xml. please, give me information each of code above. i had problem. and i understand yet about all that. ex: i have database "BANK" in sql server. and i have form in vb .net . how can i get and display this data in datagrid after pressed the button? please sir.. help me about this.
mathu mathi17y ago
in the line " NewxElement.SetAttribute("value", Acessdt.Rows.Item(inti).Item(intCol))" you have wrote the filds as attributes in xml doc but can we insert them as elements? wat is the code to do it??
- Sunitha Padmasri Pamart17y ago
  Yes we can add the fields as elements too. You first create a node and delcare it as type element. Then add this node to the parent node. I have taken only 2 fields from the database Last name and first name. Earlier i was adding the fields as attributes. - <customer> <LastName value="Holford" /> <FirstName value="Raymond" /> But now when the fields are added as elements i got like this - <customer> <LastName> <Holford /> </LastName> <FirstName> <Raymond /> </FirstName> </customer> The following is the code for it. For intCol = 0 To Acessdt.Columns.Count - 1 Dim xSubNode As XmlNode Dim strTemp As String xNode = XmlDoc.CreateNode(XmlNodeType.Element, Acessdt.Columns(intCol).Caption, Nothing) strTemp = Acessdt.Rows.Item(inti).Item(intCol) xSubNode = XmlDoc.CreateNode(XmlNodeType.Element, strTemp, Nothing) xNode.AppendChild(xSubNode) NewxElement = xElement.AppendChild(xNode) Next intCol Hope i answered your question.
mathu mathi17y ago
this works well but can we trnasfer only the selected fields in a table to xml doc??
- Sunitha Padmasri Pamart17y agoedited
  Yes you can transfer any selected fields to xml. All you need to do is pass the query with the selected fields. The query string in located in GetDataFromAcessFile procedure. Eg: strQuery = "Select LastName, FirstName from Customers" Here i have selected the lastname and the first name fields from the acess database file. Now only these fields will be written into the xml file. - <customer> <LastName value="Holford" /> <FirstName value="Raymond" /> </customer> - <customer> <LastName value="Collin" /> <FirstName value="Joy" /> </customer>