We don't bite newbies here... much | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
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 In reply to accessing MS Access databases by memo.garciasir
|
|