|Think about Loose Coupling|
accessing MS Access databasesby memo.garciasir (Acolyte)
|on Oct 15, 2010 at 21:04 UTC||Need Help??|
memo.garciasir has asked for the wisdom of the Perl Monks concerning the following question:
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?