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
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: accessing MS Access databases
by BrowserUk (Patriarch) on Oct 16, 2010 at 01:28 UTC | |
by Jim (Curate) on Oct 16, 2010 at 05:19 UTC | |
by Jim (Curate) on Oct 16, 2010 at 01:35 UTC | |
Re: accessing MS Access databases
by sundialsvc4 (Abbot) on Oct 16, 2010 at 00:02 UTC | |
by BrowserUk (Patriarch) on Oct 16, 2010 at 00:23 UTC | |
by mr_mischief (Monsignor) on Oct 16, 2010 at 01:23 UTC | |
by BrowserUk (Patriarch) on Oct 16, 2010 at 02:06 UTC | |
Re: accessing MS Access databases
by Jim (Curate) on Oct 16, 2010 at 01:25 UTC |
Back to
Seekers of Perl Wisdom