0

I have a macro that inserts data from Excel into an Access table. Each time it runs there may be 10k -250k rows to insert. I have experimented with using an empty database/table but it still takes 60s+ to run. Are there any ways to speed it up?
Thanks
Option Explicit
Sub CopyToAccess()
Dim access...