bob fitz
AWF VIP
- Local time
- Today, 22:17
- Joined
- May 23, 2011
- Messages
- 4,727
From memory, using the VBA code that I wrote, it took about 60 seconds to write 14,706 test records into the single price table producing 58,824 new records. But the process is expected to be "ongoing" with thousands of new records added every day. The proposed solutions, using queries, from Chris and Arne, produce the same result in the blink of an eye.Curious Bob, how is the speed?
I'm so glad I asked the question here and as always, so very grateful to everybody that has contributed to the discussion.
I've learnt so much from forums like this one. That's why I try to help others here when I can, although I have to say that my efforts are often superfluous as there are so many knowledgeable members here.