If you need to verify each record before deciding if you insert, I'd suggest having a counter that not only shows how many records have been processed, but also allows you to DoEvents every 10 or 20 inserts.
If your computer acts sluggish, you can DoEvents more often. If not, you can see if...