Well - being a "Jack of all trades" for a long time as well - I'd say that by far and large, NOT programming your data access to use stored...

You can't have <Items/> be children of other <Items/> - that's no longer a "valid" xml document, which seems to be why it's collapsing them back to one level only.

you'll...

Do you have triggers on the destination table?  Have you tried importing the SAME data into a blank table, or one with no validation, or indexes?  Sometimes it's not the...

I'm showing up late to the party - so most of the good suggestions are taken.  First and foremost - get the MDB off...

Have you tried playing with the order of the queries a bit?  Looks to me that you could do a lot with putting the delete first and making sure your...