I have Office 2003 Professional. At work it is conventional to use Access for
some tasks. As most of you will appreciate, Access is a mere toy. Almost any
task that could (or more usually, could not) be achieved in Access can be
performed much more easily in Excel. We have a number of large databases (
300,000 records) that I want to rationalise and modernise in Excel. My
ultimate aim is to trash Access and do everything in one spreadsheet. Is this
possible with some kind soles code snippet? Please help me impress my boss!