memo.garciasir has asked for the wisdom of the Perl Monks concerning the following question:
Hi
I'm programming an interface that can manipulate data in a MS Access database. For that, I'm using use Win32::OLE.
It works fine until I try to insert a quite large number of records, more than 100K. It takes a 2-3 minutes inserting them one by one (foreach loop). The same action take a couple of seconds using the import table from file option in the MS Access program
Someone can teach me the way of doing a bulk insert?
thanks
memo
Back to
Seekers of Perl Wisdom