I have been endeavouring to place data from tables within Access into an Outlook contacts folder. The process works OK, but it's the time it takes that bothers me.
I have about 20000 records to copy, so this should take about 6 hours. When I first set the routine in motion the records are transferred at the rate of about one per second. I leave the program running overnight, an no-one else is on the network. When I return in the morning some 16 hours later it is only up to the letter K, and is transferring at the rate of one record every 1.5 minutes.
Is this because it is a flat file and must walk through all the records before adding a new one, or have I got something wrong?