by JeffG » Thu Nov 06, 2014 4:52 pm
Have you considered exporting to a DBF file and using Access? Excel is not really built to handle records of that volume. Access will do it with ease.
Or better still, from within Access, create a dynamic external link to the capital customer table. In doing so, every time you open the access database, all of your records in Capital will always be current.