I have attached an excel sheet to an access database to process the data. I
have a record counter showng the progress of record being processed. The
counter whizzes along for 500 records and then stops for one or two minutes.
This is repeated for every 500 records.
Is there any way of speeding up the process as I have sheets with 20-30,000
The system is obviously buffering it somehow but is there any way of
changing the buffer size?
If anyone knows what I'm talking about and can suggest an answer would you
and the request is quite urgent.
Thanks in Advance