Access database with 1.8 million addresses
Needing to do some cold calling to drum up a bit of business I've bought myself the Yell UK Business Directory - amazing value at only £79 with 1.8 million addresses, phone number, no of employees, ISIC codes etc ( http://www.yell123.com/index.php?event=detail&id=12 )
My problem is that it comes in an Access database, and at 1.4 gigabytes and 1.8 million records my PC is grinding to a halt trying to handle it.
To make it manageable I'd like to chop it up into separate files - one for each county. But whatever I try, it simply locks up.
Can any Access expert tell me the simplest way of achieving this? Thanks