If you're updating data then you'd probably get more control using ADO.
Plenty of examples if you google for "ADO VBA insert"

Tim

"Tomo" wrote in message
...
How can I issue commit method to QueryTables