Same response.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KJ" wrote in message
...
Apologies should read 30,000 records

"Bob Phillips" wrote:

It sounds to me that you are going the wrong way. What is wrong with
using
Access? 300,000 records for Excel is excessive, for one thing a
spreadsheet
only has 65,000+ rows.

If you want to impress your boss, find ways to extract summarised data
(small amounts, nowhere near 300,000 records) and use Excel's proper
functionality to analyse it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"KJ" wrote in message
...
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!