Ignore/Suppress 31550 Error in VBA (ImportXML)

[Heatshiver]

I have the following code for importing and appending table data:

Application.ImportXML _
 DataSource:="c:\TEST.xml", _
 ImportOptions:=acAppendData

The code works perfectly. It gives the error that I am trying to create duplicate index fields, and then create an "ImportErrors" table; which is completely correct as far as how it is working.

I would like to ignore/suppress the 31550 Error it gives after importing the table data. I have tried several solutions, including naming a Const and making that the error number, then adding Response = acDataErrContinue in the Sub Form_Error without success. How do I do this?

I can create code to delete the table it creates, but I may want that for my own purposes later down the road.

[June7]

Cross post http://www.access-programmers.co.uk/...d.php?t=242623

[Heatshiver]

Congrats! But do you have an applicable answer?

[June7]

Nothing more than already offered in the other thread. Maybe this is an error that can't be trapped.

You might review http://forum-services-review.toptenr...ette-tips.html
Item 11:
Do not double post (post the same message twice in one thread) or cross post (place the same message across several forums).

If you do cross-post the courtesy is to indicate that and provide link to other thread(s).

[Heatshiver]

That is my fault as I didn't intend to post here, I normally post at the other two. Thanks!