UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> Xml Import Issues    
 
   
Steve25
post Feb 23 2012, 03:23 PM
Post #1

New Member
Posts: 6
Hi,

I'm trying to import/merge/update a table from an xml file.

To import I'm using the following code:
QUOTE
Private Sub Command0_Click()

Const acAppendData = 2
Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase "DATABASE LOCATION"
objAccess.ImportXML "HTTP OF XML FILE", acAppendData

End Sub

This works perfectly to import new records, however what I also need it to do is merge/update the data. So the xml file will contain the correct data and any amendments need to be made to the Access table.

Any help greatly appreciated.

Steve

PS I'm using Access 2010
Go to the top of the page
 
+

Posts in this topic
- Steve25   Xml Import Issues   Feb 23 2012, 03:23 PM
- - ScottGem   I would import the file to a temp table, then run ...   Feb 23 2012, 04:11 PM
- - Steve25   Thanks for the reply. That sounds like the sort o...   Feb 23 2012, 05:01 PM
- - ScottGem   Sure, You can use DoCmd.DeleteObject. And then us...   Feb 24 2012, 07:55 AM

« Next Oldest · Access Automation · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Switch to: Standard · Switch to: Linear+ · Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 01:58 PM