@tg.


.Properties("append-only rowset") = True

works with some OLEDB providers like Jet.
actually last I checked that didn't work with SQL Server, but who knows given his connection string......